Target & Version

PRQL

SQL

  *
FROM
ORDER BY
  age
LIMIT
  10

PRQL

SQL

SELECT
  TOP (10) *
  employees
ORDER BY
  age

Supported dialects

• sql.ansi
• sql.bigquery
• sql.clickhouse
• sql.hive
• sql.mysql
• sql.postgres
• sql.sqlite
• sql.snowflake
• sql.duckdb

Version

PRQL

SQL

SELECT
  *
FROM
  employees

• 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.