I share your opinion that SQL is a very flawed language but it is still the best option I know of. I am absolutely sure someone could make a better SQL from sc

I share your opinion that SQL is a very flawed language but it is still the best option I know of. I am absolutely sure someone could make a better SQL from scratch. (But you are correct that most people won't be able to.) I am not a language designer but I've been working on an SQL generator (almost DSL) in Racket. Although it's still very rough, I like it better than SQL for writing views and stored procedures. Imagine if a world-class language designer developed a new query language for your RDBMS of choice. It would probably fix most of the things you loathe.