Because you never learned SQL properly, from the sound of it.
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 (._.`))
Also, ORMa produce trash queries and are never expressive enough.
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
Me trying to remember on whose output data
having
,count
,sum
, etc. workOnce you know functions you would have no reason to go back.
I propose we make SQL into this:
const MAX_AMOUNT = 42 database .from(table) .where( (amount) => amount < MAX_AMOUNT, table.field3 ) .select(table.field1, table.field3) .having( (id) => count(id) table.field0 )
…and I bet I just reinvented the wheel, maybe some JavaScript ORM?
most languages have some first or third party lib that implements a query builder
Because you never learned SQL properly, from the sound of it.
Also, ORMa produce trash queries and are never expressive enough.
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
ORMs produce good queries if you know what you do. Which requires proper knowledge of SQL, unfortunately.
Check out Spark: https://github.com/apache/spark/blob/master/examples/src/main/python/sql/basic.py