Guru's Verification engine ensures consistency, confidence, and trust in the knowledge your organization shares. Learn more.

q/kdb+ | qSQL (SQL-like queries)

It is possible to query kdb tables in an SQL-like form [1]. Though this format is not at all similar to standard q code, it does provide a more gentle learning curve for those who come from a SQL background.

Note that while convenient for exploratory analysis, this form is not conducive to writing programmatic code, because it is not possible to indirectly reference table or column names (i.e. through variables rather than direct names). For that, the functional query form [2] must be used.

Resources:

[1] https://code.kx.com/q/basics/qsql/
[2] [wip] q functional query form

You must have Author or Collection Owner permission to create Guru Cards. Contact your team's Guru admins to use this template.