3 ms·
That's a good point. It would be very nice to have a LLVM IR-style language for database queries, though. As a language, SQL is... well, a little behind times.
by Yoric 2y ago
That's a good point.
It would be very nice to have a LLVM IR-style language for database queries, though. As a language, SQL is... well, a little behind times. ORMs explore lots of interesting design choices, but as you mention, by piling up high-level decisions on top of something that, by many aspects, are even higher decisions.
I wonder what an LLVM IR-like would look like in this space.
- ninetyninenine 2y agoI agree there should be a common api. The sheer number of dialects with SQL contributes to a lot of issues with ORMs. But SQL is definitely not something designed for computers to only write or compile another language into (which is what the OP is promoting).
- Yoric 2y agoYeah. I wonder if something like GlueSQL or the IndexedDB layer of most browsers could be used as such an API.