Skip to main content

AggregateExpr

One aggregation output: an allowlisted function over a column, named by alias. count may omit column (a row count). Raw SQL / arbitrary expressions are intentionally not representable.

functionFunction (string)required

Allowlisted aggregate function

Possible values: [sum, count, avg, min, max]

column object

Aggregated column (omit only for count)

anyOf
string
aliasAlias (string)required

Output column name

AggregateExpr
{
  "function": "sum",
  "column": "string",
  "alias": "string"
}