Function getSelectExpr

packages/infra/src/Store/SQL/query.ts:530–551

()

    : false

  const getSelectExpr = (): string => {
    if (!select) return "id, _etag, data"
    const fields = select.map((s) => {
      if (typeof s === "string") {
        if (s === idKey || s === "id") return `id`
        if (s === "_etag") return `_etag`
        return `${dialect.jsonExtractJson(s)} AS "${s}"`
      }
      if ("computed" in s) {
        return computedSelectExpr(s.key, s.computed)
      }
      if ("aggregate" in s) {
        return aggregateSelectExpr(s.key, s.aggregate)
      }
      if ("path" in s) {
        // Group-by fields: extract as scalar (not JSON-encoded) so grouping works and values compare as plain strings/numbers
        return `${fieldExpr(dottedToJsonPath(s.path))} AS "${s.key}"`
      }
      return `${dialect.jsonExtractJson(s.key)} AS "${s.key}"`
    })
    return fields.join(", ")
  }

  // Order matters: projection params must be emitted BEFORE user-filter
  // params so positional `?` placeholders in SQLite match `params[]` order.