You're missing the forest for the trees. SQL & RDBMS' support use cases that might as well be cheats with how easy it makes it to do non-trivial queries. > In

You're missing the forest for the trees. SQL & RDBMS' support use cases that might as well be cheats with how easy it makes it to do non-trivial queries. > In summary I think a QL should produce a table from a database In SQL we call these projections, which is just whatever columns are being returned from the amalgamation of tables you used in your query. This could include aggregations or window functions. Things are possible in SQL that are simply more difficult with anything else, and my time and my companies are more important than figuring out the perfect approach to every problem. SQL makes 80% of problems trivial, and the remaining 20% I can easily solve somewhere else (like Elasticsearch or sqlite or even custom serdes to disk).