We are pleased to announce the publication of the new SQL Standard version by the International Standards Organization (ISO), SQL:2023, and successor to the SQL:2016 Standard.
Keeping true to Oracle’s commitment to making the power of SQL accessible to everyone, Oracle once again was actively involved in driving new features into the Standard. Along the way, known bugs from the previous version were also fixed.
One of the highlights of SQL:2023 is the entirely new Part 16, SQL/PGQ, which defines ways for the SQL language to represent property graphs and to interact with them.
Another highlight is the addition of a new JSON data type. This data type is the basis for the new simplified SQL/JSON dot-notation syntax, which enables users to write less verbose SQL/JSON queries compared to using the JSON_QUERY and JSON_VALUE functions.
SQL:2023 also added a number of new scalar and aggregate functions, among others: GREATEST, LEAST, RPAD, LPAD, RTRIM, LTRIM, and ANY_VALUE.
Oracle is proud to be part of the SQL Standards community. We extend our congratulations on the publication of the new SQL Standard to all other SQL Standards community members.
A special thank you to our SQL Standards team here at Oracle: Jan Michels, Fred Zemke, Jörn Bartels as the Associate Editor of the SQL Standard, and all other employees who helped shape SQL:2023.
The 11 parts of the SQL:2023 Standard are published and available for purchase in the ISO Store:
Gerald Venzl is a Senior Director of Product Manager for Oracle. During his career, Gerald has worked as a Developer, DBA, Performance Tuner, Software Architect, Consultant and Enterprise Architect prior to his current role, while still being active as a developer in his free time and on open source projects. This allowed Gerald to live several different lives in the IT sector, providing him with a solid understanding of the concerns in these individual areas while gaining a holistic view overall. Gerald focuses on advocating how to build systems that provide flexibility yet still meet the needs of the users.