PRQL, or Pipelined Relational Query Language, is a modern language for data transformation that serves as a powerful replacement for SQL. It is designed to be readable, explicit, and declarative like SQL, but offers additional features such as logical pipelines, variables, and functions. PRQL can be used with any SQL-based database as it compiles to SQL. It supports operations like filtering, aggregating, deriving new columns, grouping, sorting, and more. The language has its own syntax and allows for concise expressions. While still in active development, PRQL is usable for simple queries and is being developed with a focus on adding features, ensuring robustness, and making it accessible to users. Users can explore and experiment with PRQL using the PRQL Playground.
https://github.com/PRQL/prql