PRQL allows specifying a target dialect at the top of the query, which allows PRQL to compile to a database-specific SQL flavor.
prql target:sql.postgres from employees sort age take 10
SELECT * FROM employees ORDER BY age LIMIT 10
prql target:sql.mssql from employees sort age take 10
SELECT TOP (10) * FROM employees ORDER BY age
Note that dialect support is early — most differences are not implemented, and
most dialects’ implementations are identical to
generic’s. Contributions are
PRQL allows specifying a version of the language in the PRQL header, like:
This has two roles, one of which is implemented:
- The compiler will raise an error if the compiler is older than the query version. This prevents confusing errors when queries use newer features of the language but the compiler hasn’t yet been upgraded.
- The compiler will compile for the major version of the query. This allows the language to evolve without breaking existing queries, or forcing multiple installations of the compiler. This isn’t yet implemented, but is a gating feature for PRQL 1.0.