<!-- markdownlint-disable MD042 — some pages aren't finished yet (though the graying out of top level pages is not ideal — it's either that, or links to pages that are blank. Or maybe we try and write a useful page for each heading?) -->

Introduction

Introduction

Tutorial

A friendly & accessible guide for learning PRQL. It has a gradual increase of difficulty and requires only basic understanding of programming languages. Knowledge of SQL is beneficial, because of many comparisons to SQL, but not required.

• Relations
• Filtering
• Aggregation

<!-- We used to have a "How do I", which I think would be good, but we didn't build enough to maintain it. If we find the Reference or Tutorial has enough content that we could move here, we could start it again --> <!-- # How do I? -->

Reference

In-depth information about the PRQL language. Includes justifications for language design decisions and formal specifications for parts of the language.

• Syntax

  • Literals
  • Strings
    • F-strings
    • R-strings
    • S-strings
  • Tuples
  • Arrays
  • Identifiers & keywords
  • Function calls
  • Pipes
  • Operators
  • Case
  • Ranges
  • Comments
  • Parameters

• Importing data

  • From
  • Reading files
  • Ad-hoc data

• Declarations

  <!-- I don't know what to call this section. -->
  • Variables — let & into
  • Functions

• Standard library

  • Transforms

    • Aggregate
    • Append
    • Derive
    • Filter
    • Group
    • Join
    • Loop
    • Select
    • Sort
    • Take
    • Window

  • Aggregation functions

  • Date functions

  • Mathematical functions

  • Text functions

  • Removing duplicates

• Specification

  • Null handling
  • Name resolution
  • Modules
  • Type system

Project

General information about the project, tooling and development.

• Changelog

• Target & version

• Bindings

  • .NET
  • Elixir
  • Java
  • JavaScript
  • PHP
  • Python
  • R
  • Rust

• Integrations

  • prqlc CLI
  • ClickHouse
  • Jupyter
  • DuckDB
  • QStudio
  • Prefect
  • VS Code
  • PostgreSQL
  • Databend
  • Rill
  • Syntax highlighting

• Contributing to PRQL

  • Development
  • Language design