Me trying to remember on whose output data having, count, sum, etc. work
Once you know functions you would have no reason to go back.
I propose we make SQL into this:
const MAX_AMOUNT = 42, MIN_BATCHES = 2
database
.from(table)
.where(
(amount) => amount < MAX_AMOUNT,
table.field3
)
.select(table.field1, table.field3)
.group_by(table.field1)
.having(
(id) => count(id) >MIN_BATCHES
table.field0
)
(Sorry for any glaring mistakes, I'm too lazy right now to know what I'm doing)
..and I bet I just reinvented the wheel, maybe some JavaScript ORM?