kdbs q-sql does improve a lot on that. Especially expressiveness.

https://code.kx.com/q/ref/qsql/ http://www.timestored.com/b/kdb-qsql-query-vs-sql/