> 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.
What if the query is implemented in a lower level and more efficient programming language, or probably a completely separate DB engine.
The benefits of having a well designed Turing complete language available for the filtering criteria far outweigh the disadvantages.