Search Shortcut cmd + k | ctrl + k

- Overview
- Documentation
- Development
- Download Metrics
- FAQ
- Core Extensions
- List of Community Extensions

- quack
- magic
- flockmtl
- http_client
- crypto

prql
Downloads 339this week

Support for PRQL, the Pipelined Relational Query Language

Extension repository on GitHub
Extension descriptor (YAML)

### Installing and Loading

    INSTALL prql FROM community;
    LOAD prql;

### Example

    let invoices = s"select * from 'https://raw.githubusercontent.com/PRQL/prql/0.8.0/prql-compiler/tests/integration/data/chinook/invoices.csv'"
    let customers = s"select * from 'https://raw.githubusercontent.com/PRQL/prql/0.8.0/prql-compiler/tests/integration/data/chinook/customers.csv'"
    from invoices
    filter invoice_date >= @1970-01-16
    derive {
      transaction_fees = 0.8,
      income = total - transaction_fees
    }
    filter income > 1
    group customer_id (
      aggregate {
        average total,
        sum_income = sum income,
        ct = count total,
      }
    )
    sort {-sum_income}
    take 10
    join c=customers (==customer_id)
    derive name = f"{c.last_name}, {c.first_name}"
    select {
      c.customer_id, name, sum_income
    }
    derive db_version = s"version()"

### About prql

The PRQL extension adds support for the Pipelined Relational Query Language.