Function getDateQuery

src/server/model/insights/shared.ts:77–92

(
    field: string,
    unit: string,
    timezone: string
  )

  }

  protected getDateQuery(
    field: string,
    unit: string,
    timezone: string
  ): Prisma.Sql {
    if (this.shouldUseClickhouse()) {
      return this.getClickHouseDateQuery(field, unit, timezone);
    }

    // Check if unit exists in POSTGRESQL_DATE_FORMATS before using it
    if (!(unit in POSTGRESQL_DATE_FORMATS)) {
      throw new Error(`Invalid date unit: ${unit}`);
    }

    return sql`to_char(date_trunc(${unit}, ${raw(field)} at time zone ${timezone}), '${raw(POSTGRESQL_DATE_FORMATS[unit as keyof typeof POSTGRESQL_DATE_FORMATS])}')`;
  }

  protected getClickHouseDateQuery(
    field: string,