Comment by remywang
9 hours ago
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.