I’m gonna dig into this, it seems awesome, but as a long-time SQL user your SQL examples [1] look like junior-level bloat and immediately make me question the entire project.
This is great; I have been thinking about this for a long time. I like reading about past and current implementations that try to better sql; from a programming and a data science and performance perspective. I am aware of the ones you linked and some others like 'Real' (shakti.com) sql and some enhancements from papers.
I’m gonna dig into this, it seems awesome, but as a long-time SQL user your SQL examples [1] look like junior-level bloat and immediately make me question the entire project.
[1] https://trilogydata.dev/thesis/
I was reading this comment and I have no expertise in sql; would you like to explain why do exemples "look like junior-level bloat" to you ?
This is great; I have been thinking about this for a long time. I like reading about past and current implementations that try to better sql; from a programming and a data science and performance perspective. I am aware of the ones you linked and some others like 'Real' (shakti.com) sql and some enhancements from papers.
Anyway; nice one! Will try.
Not a SQL replacement, but if you're looking for an open source semantic layer, Cube is the way to go [0]
0 - https://github.com/cube-js/cube