The remaining 1% is usually uncomfortable if not down right painful.

But yes, I agree a query optimizer is valuable. Luckily there’s nothing stopping us from implementing one, as Prela is algebraic and all optimization techniques for SQL carry over.

Linq, in dot net, is a real life working example of what you’re talking about and it’s agnostic of how the storage is structured.

That said I still rarely use the but the basics of Linq. I just don’t see the upgrade of what you’re solving here.