const query = ctx.db
.select({
...groupByFilters,
rowCount: sql<number>`count(${schema.returns.id})`.as(
"row_count",
),
data: sql`json_agg(${schema.returns})`,
})
.from(schema.returns)
.groupBy(...Object.values(groupByFilters))
.limit(limit + 1); // limit the amount of groups returned
const query = ctx.db
.select({
...groupByFilters,
rowCount: sql<number>`count(${schema.returns.id})`.as(
"row_count",
),
data: sql`json_agg(${schema.returns})`,
})
.from(schema.returns)
.groupBy(...Object.values(groupByFilters))
.limit(limit + 1); // limit the amount of groups returned