kdbs q-sql does improve a lot on that. Especially expressiveness. https://code.kx.com/q/ref/qsql/ https://code.kx.com/q/ref/qsql/ http://www.timestored.com/b/k

kdbs q-sql does improve a lot on that. Especially expressiveness. https://code.kx.com/q/ref/qsql/ https://code.kx.com/q/ref/qsql/ http://www.timestored.com/b/kdb-qsql-query-vs-sql/ http://www.timestored.com/b/kdb-qsql-query-vs-sql/