Because SQL Is Everywhere
summary
The talk explains why SQL remains ubiquitous in data work and introduces Ibis, a pure-Python library that provides a DataFrame-like API to build composable, concise queries that run on many backends (SQLite, DuckDB, Postgres, Spark, ClickHouse, Snowflake, BigQuery, etc.). It targets data engineers and scientists who struggle with translating Pandas prototypes to distributed engines, managing large SQL templates, or avoiding SQL when trying tools like DuckDB, showing how Ibis can replace string-templated SQL and unify workflow across execution engines.
AI-written summary · about
chapters (9)
- 0:00Introduction
- 1:11Data tool problems
- 3:38Local versus remote gap
- 5:41SQL production challenges
- 9:30SQL string generation
- 14:28Ibis presentation
- 18:05Ibis demo
- 24:08Ibis benefits and limits
- 25:46Future and Q&A
related talks
32mBecause SQL is everywhere but you don't want to use it
28mIbis framework, Making data science work at any scale
01h 17mIbis: A fast, flexible, and portable tool for data analytics
44mIbis- Expressive analytics in Python at any scale
42mIbis: Don't Let the Engine Dictate the Interface
41mData Engineers: Respect the Resiliency of SQL
44mNonrelational SQL
32mUnlearning SQL