Function aggregateSelectExpr

packages/infra/src/Store/SQL/query.ts:506–524

(key: string, agg: AggregateIrExpression)

  }

  const aggregateSelectExpr = (key: string, agg: AggregateIrExpression): string => {
    switch (agg._tag) {
      case "agg-count":
        return `COUNT(1) AS "${key}"`
      case "agg-count-when": {
        if (agg.filter.length === 0) return `COUNT(1) AS "${key}"`
        const cond = print([{ t: "where-scope", result: agg.filter, relation: "some" }], null, false)
        return `COUNT(CASE WHEN ${cond} THEN 1 END) AS "${key}"`
      }
      case "agg-sum":
        return `COALESCE(SUM(${fieldExpr(agg.field)}), 0) AS "${key}"`
      case "agg-min":
        return `MIN(${fieldExpr(agg.field)}) AS "${key}"`
      case "agg-max":
        return `MAX(${fieldExpr(agg.field)}) AS "${key}"`
      default:
        return assertUnreachable(agg)
    }
  }

  const hasAggregates = select
    ? select.some((s) => typeof s === "object" && s !== null && "aggregate" in s)