Hacker News new | ask | show | jobs
by husam212 772 days 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.

1 comments

What 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.

The 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.