PRQL compiler

prqlc is the reference implementation of a compiler from PRQL to SQL, written in Rust. It also serves as the CLI.

For more on PRQL, check out the PRQL website or the PRQL repo.

CLI

prqlc serves as a CLI for the PRQL compiler. It is a single, dependency-free binary that compiles PRQL into SQL.

Usage

prqlc compile

This command works as a filter that compiles a PRQL string into an SQL string.

  1. $ echo 'from employees | filter has_dog | select salary' | prqlc compile
  2. SELECT
  3. salary
  4. FROM
  5. employees
  6. WHERE
  7. has_dog

A PRQL query can be executed with CLI tools compatible with SQL, such as DuckDB CLI.

  1. $ curl -fsL https://raw.githubusercontent.com/PRQL/prql/0.12.2/prqlc/prqlc/tests/integration/data/chinook/albums.csv -o albums.csv
  2. $ echo 'from `albums.csv` | take 3' | prqlc compile | duckdb
  3. ┌──────────┬───────────────────────────────────────┬───────────┐
  4. album_id title artist_id
  5. int64 varchar int64
  6. ├──────────┼───────────────────────────────────────┼───────────┤
  7. 1 For Those About To Rock We Salute You 1
  8. 2 Balls to the Wall 2
  9. 3 Restless and Wild 2
  10. └──────────┴───────────────────────────────────────┴───────────┘

Executing this command without any argument will start interactive mode, allowing a PRQL query to be written interactively. In this mode, after writing PRQL and press Ctrl-d (Linux, macOS) or Ctrl-z (Windows) to display the compiled SQL.

  1. prqlc compile

Just like when using it as a filter, SQL string output can be passed to the DuckDB CLI and similar tools.

  1. $ prqlc compile | duckdb
  2. Enter PRQL, then press ctrl-d to compile:
  3. from `albums.csv`
  4. take 3
  5. ┌──────────┬───────────────────────────────────────┬───────────┐
  6. album_id title artist_id
  7. int64 varchar int64
  8. ├──────────┼───────────────────────────────────────┼───────────┤
  9. 1 For Those About To Rock We Salute You 1
  10. 2 Balls to the Wall 2
  11. 3 Restless and Wild 2
  12. └──────────┴───────────────────────────────────────┴───────────┘

Installation

Packaging status

via Homebrew (macOS, Linux)

  1. brew install prqlc

via winget (Windows)

  1. winget install prqlc

From GitHub release page

Precompiled binaries are available for Linux, macOS, and Windows on the PRQL release page.

From source

  1. # From crates.io
  2. cargo install prqlc
  1. # From a local PRQL repository
  2. cargo install --path prqlc/prqlc

Shell completions

The prqlc shell-completion command prints a shell completion script for supported shells, and saving the printed scripts to files makes for shells to load completions for each session.

Bash

For Linux:

  1. prqlc shell-completion bash >/etc/bash_completion.d/prqlc

For macOS:

  1. prqlc shell-completion bash >/usr/local/etc/bash_completion.d/prqlc

fish

  1. prqlc shell-completion fish >~/.config/fish/completions/prqlc.fish

PowerShell

  1. mkdir -Path (Split-Path -Parent $profile) -ErrorAction SilentlyContinue
  2. prqlc shell-completion powershell >path/to/prqlc.ps1
  3. echo 'Invoke-Expression -Command path/to/prqlc.ps1' >>$profile

zsh

  1. prqlc shell-completion zsh >"${fpath[1]}/_prqlc"

Ensure that the following lines are present in ~/.zshrc:

  1. autoload -U compinit
  2. compinit -i

Helpers

Cheat sheets for prqlc are available on various websites and with various tools.

Library

For more usage examples and the library documentation, check out the prqlc documentation.

Library installation

  1. cargo add prqlc

Examples

Compile a PRQL string to a SQLite dialect string:

  1. #![allow(unused)]
  2. fn main() {
  3. // In a file src/main.rs
  4. use prqlc::{compile, Options, DisplayOptions, Target, sql::Dialect};
  5. let prql = "from employees | select {name, age}";
  6. let opts = &Options {
  7.     format: false,
  8.     target: Target::Sql(Some(Dialect::SQLite)),
  9.     signature_comment: false,
  10.     display: DisplayOptions::Plain,
  11.     ..Default::default()
  12. };
  13. let sql = compile(&prql, opts).unwrap();
  14. assert_eq!("SELECT name, age FROM employees", sql);
  15. }