Lambda Functions and List Operations in DuckDB SQL
Explore efficient LIST-type operations and Python-style list comprehension in SQL databases through this 25-minute technical talk from the Dutch Seminar on Data Systems Design. Discover how DuckDB, a high-performance relational database system for analytics, implements internal design choices to support LIST values efficiently, particularly when working with nested input formats like JSON. Learn about the challenges and solutions in leveraging SQL engines' potential while maintaining ease of use, without requiring additional unnesting steps or normalized data loading. Presented by Tania Bogatsch, a software engineer at DuckDB Labs with experience in adaptive expression reordering, this talk offers valuable insights for researchers and practitioners working on data systems design and implementation.