We can't find the internet
Attempting to reconnect
Something went wrong!
Hang in there while we get back on track
Peter Eisentraut: The SQL standard: Where does it come from? Where does it go? (PGConf.EU 2023)
Discover the intricacies of the SQL standardization process, from ISO and WG3 to national bodies, and learn about the latest features and updates in SQL 2023, including changes to NULL treatment and JSON type.
- SQL standardization process involves multiple organizations and layers, including ISO and WG3, with various committees and meetings.
- SQL community is relatively small, around 10-15 people, and includes representatives from companies like PostgreSQL, Oracle, and Microsoft.
- SQL is updated in 3-year cycles, with the latest version being SQL 2023.
- The standardization process involves multiple drafts, DIS comment resolution, and FDIS publication.
- Implementations, like PostgreSQL, can contribute to the standardization process, but there are trade-offs and politics involved.
- National bodies, like the German national body, play a key role in the standardization process.
- Comments and participation from national bodies can influence the standardization process.
- SQL 2023 includes changes to the NULL treatment clause, JSON type, and simplified accessor.
- The SQL standardization process is slow, with a slow pace of changes, and prioritizes stability and compatibility over new features.
- There are various levels of the standardization process, including SC32, JTC1, and ISO.
- Meeting formats can vary, with in-person meetings, virtual meetings, and a mix of both.
- Virtual meetings involve dial-in and presentation, while in-person meetings are held in conference rooms.
- The standardization process is formal, requiring paperwork and commitment from national bodies.
- Compliance with the standard is voluntary, but influential vendors are likely to follow it.
- SQL 2023 includes new features like row pattern recognition and graph data processing.
- The SQL standardization process can be complex, involving multiple documents, changes, and drafts.