3 ms·
My issue with SQL is lack of composability and difficulty of debugging intermediate results.
by drivebyhooting 1y ago
My issue with SQL is lack of composability and difficulty of debugging intermediate results.
- asadm 1y agois it a language problem though? it's just lack of tooling.
- theLiminator 1y agoThe dataframe paradigm (a good example being polars) is another good alternative that's more composable (imo).
- fifilura 1y agoIt is true. I still hate it. I think because it always offers 10 different ways to do the same thing. So it is just too much to remember.
- mamcx 1y agoYes, SQL is poor. What could be good is relational + array model. I have some ideas on https://tablam.org https://tablam.org, and building not just the language but the optimizer in tandem I think will be very nice.
- oembar4 1y agoThe programming style reminds me of the old days of clipper and xbase family, even ABAP. I like the syntax.
- kragen 1y agoThe standard things that someone should always say when someone brings up this problem is: • Datalog is much, much better on these axes. • Tutorial D is also better than SQL.
- zozbot234 1y agoYou can use SQL CTE's and/or VIEW's as a composable abstraction over queries and inspect intermediate results. The language features are there.
- Too 1y agoCheck out https://prql-lang.org/ https://prql-lang.org/ It solves all the warts of sql while still being true to its declarative execution. Trailing commas, from statement first and reads as a a composable pipeline, temporary variables for expressions, intuitive grouping.