prqlc

Compile PRQL to SQL

$ prqlc compile [query.prql]

$ echo "from employees | select name" | prqlc compile

$ prqlc fmt [query.prql]

$ prqlc compile [query.prql] -o [output.sql]

prqlc command [options] [file]

prqlc is the compiler for PRQL (Pipelined Relational Query Language), a modern query language designed as a more readable and composable alternative to SQL. It transpiles PRQL source code into standard SQL that can be executed against any supported database.
PRQL uses a pipeline syntax where data transformations are chained with the pipe operator, making complex queries easier to read and write than equivalent nested SQL. The compiler supports multiple SQL dialects through the --target option, generating database-specific SQL for PostgreSQL, MySQL, SQLite, BigQuery, and others.
The fmt subcommand formats PRQL source code for consistent style, and the compiler accepts input from files or stdin for use in build pipelines.

compile

Compile PRQL to SQL.

Format PRQL code.

Output file.

Target database.

PRQL is experimental. Supports multiple SQL dialects.

PRQL was created as a modern alternative to SQL syntax.

psql(1), sqlite3(1)