Discover PRQL, a modern data transformation language, in this 30-minute conference talk from PyCon South Africa. Learn how this open-source alternative to SQL combines relational algebra with the functionality of popular data manipulation libraries like Pandas, Polars, dplyr, and LINQ. Explore the language's functional, pipelined query paradigm through interactive Python examples while understanding its core features including f-strings, @date literals, and the ?? coalesce operator. Gain insights into how PRQL simplifies complex analytical queries through its orthogonal language constructs and seamless composition of data pipelines for filtering, transformation, and aggregation processes. Understand how PRQL's multi-dialect SQL transpilation ensures compatibility with existing relational databases and data warehouses, allowing for immediate integration with current data infrastructure.
Overview
Syllabus
Time: Oct 05 Thu:
Duration:
Taught by
PyCon South Africa