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

on YouTube ↗39m

" summary

Historic standards milestones and concrete demos decide this: live examples of recursion in SQL that can be copy‑pasted to return hierarchical rows, window functions used to compute running balances and percentiles, and JSON_TABLE mapping that turns a JSON document into rows for direct INSERTs. Coverage lists which engines already implement each feature (Postgres, MariaDB, BigQuery, commercial DBs) and explains system vs application time‑travel. Clear demos, compatibility notes, and adoption status tell whether it’s worth watching.

AI-written summary · about

" chapters (7)

1. 0:00Introduction
2. 0:30The relational idea
3. 4:50SQL 99
4. 13:10SQL 2003
5. 19:07Median
6. 24:06SQL Standard
7. 29:40Time Travel

" related talks

• 45mMore Than a Query Language: SQL in the 21st CenturyMarkus Winand · Dutch PHP Conference 2019
• 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
• 58mThe Mother of All Query Languages: SQL in the 21st CenturyMarkus Winand · Dev Day Dresden 2019
• 41mModern SQL: Evolution of a dinosaurMarkus Winand · WebCamp Zagreb 2018
• 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