More Than a Query Language: SQL in the 21st Century

on YouTube ↗45m

" summary

SQL since SQL:1999 adds non‑relational types and transformations: recursive CTEs let one query return an entire subtree, window functions compute running balances without GROUP BY, SQL:2016’s JSON_TABLE turns a JSON bind into tabular rows for a single round‑trip insert, and temporal tables (system and application versioning) keep history automatically. Major dialects adopt these features (MySQL 8.0 in 2018; SQLite lags), the standard swells to ~4,000 pages and an estimated 80% of the spec extends beyond classic relational SQL.

AI-written summary · about

" chapters (6)

1. 0:00Start
2. 3:01Normalization
3. 14:04composite types (object)
4. 16:28UNION ALL
5. 25:12ROWS BETWEEN
6. 41:14the relational idea

" related talks

• 46mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · code.talks 2019
• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Devoxx Belgium 2019
• 39mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Big Data Conference Europe 2019
• 58mThe Mother of All Query Languages: SQL in the 21st CenturyMarkus Winand · Dev Day Dresden 2019
• 50mModern SQL: Evolution of a dinosaurMarkus Winand · Riga Dev Days 2019
• 48mModern SQL: Evolution of a DinosaurMarkus Winand · DevConf 2018
• 47mModern SQL: Evolution of a DinosaurMarkus Winand · International PHP Conference Spring 2019
• 01h 00mModern SQL: Evolution of a DinosaurMarkus Winand · JAX 2019