Modern SQL: Evolution of a dinosaur

on YouTube ↗50m

" summary

Claims that SQL left pure relational rules in 1999 and now includes Turing-complete SQL features: graph-like processing, semantic XML/JSON queries, pattern recognition and built-in history. Demonstrations use window functions for sessionization and running totals, MATCH_RECOGNIZE or regex-based pattern matching for event sequences, and SYSTEM_VERSIONING / temporal tables to keep automatic historical versions without changing the app; JSON_TABLE/JSON path transforms documents into rows. Standard updates (2006, 2016) add these features but vendor support remains uneven.

AI-written summary · about

" chapters (6)

1. 0:00Introduction to Modern SQL
2. 10:00Evolution of SQL standards
3. 20:00Window functions and analytics
4. 30:00JSON and document support
5. 40:00Temporal data and versioning
6. 48:00Q&A and closing remarks

" related talks

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