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?
You might be right, though, to be fair, I also keep forgetting syntax of stuff when I don't use it very often (read SQL (._.`))
I meant to say that I would like the raw SQL syntax to be more similar to other programming languages to avoid needing to switch between thinking about different flows of logic