It seems that is the price you pay for the power to turn a 600-line nightmare SQL query into 60 lines of barely readable code.
replyI would like to see that example then.
replyI’m all for improving on SQL, but this syntax does not even solve the dangling comma issue as far as I can tell from the example.
SQL is a horrible language. I’d gladly program in something composable like Elm.
replyUnfortunately Evan removed GROUP BY in 0.19 and left to buy cigarettes.
replyIt'd definitely need a solid team behind this and not just Evan Czaplicki if I were to trust a database with my data.
replyAs a programming language? Sure. As a way to work with relational data? It may be my favorite "language" across all domains because of the terse beauty. I am a self-taught, no CS coder but SQL is the one place where I feel like I get all the math I should know.
replyAn opinionated, possibly hot take would be to call SQL "A more elegant weapon of a civilized age".
Or “the worst query language ever, except for all the alternatives”
replyMaybe so, but my father in law, who is a salesman and knows nothing about computers and programming still knows SQL.
replySQL is a horrible language in the same way Excel is -- programmers hate it but the what makes it a horrible programming language to developers is what makes it accessible to non programmers.