5 ms·
> don't bring any additional benefit to just writing code in your normal programming language What if the query is implemented in a lower level and more effici
by husam212 2y ago
> don't bring any additional benefit to just writing code in your normal programming language
What if the query is implemented in a lower level and more efficient programming language, or probably a completely separate DB engine.
- pydry 2y agoWhat if the filtering criteria required a function call? The benefits of having a well designed Turing complete language available for the filtering criteria far outweigh the disadvantages.
- chuckadams 2y agoThe disadvantages in being tied to the execution model of said Turing Complete language are also significant when compared to one that can do optimizations like stream fusion without having to work such optimizations into the language as a whole. But there's no technical reason we can't have both.