Comment by ravimakhijapi
5 hours ago
I think part of the issue is that SQL is nice for some things (do some aggregation on a row-filtered subset of columns) but perhaps not as much for other things (a query where later rows depend on earlier rows in complex ways). I think being able to compile a procedural programming language to SQL would be pretty nice for the latter.
See LINQ?
https://codeberg.org/veqq/declarative-dsls is like LinQ turned to ~11~ 50.
I love LINQ's syntax and monadic API, but that's about it.
It speed-runs juniors into thinking they are writing transactional code when they aren't.
And for seniors who are more aware of footguns and try to be careful, they're met with an inability to do so (e.g. upserts).