SQL:2023 has been wrapped. The final text has been submitted by the working group to ISO Central Secretariat, and it’s now up to the ISO gods when it will be published. Based on past experience, it could be between a few weeks and a few months.

In the meantime, we can look at what is new. The changes can be grouped into three areas:

  • Various smaller changes to the existing SQL language
  • New features related to JSON
  • A new part for property graph queries

Let’s look at each one.

All new functionality in the SQL standard is in the form of optional features, so I’m giving the feature codes and names below for reference. (But this is not an exhaustive list of all new features codes. I’m omitting some that are mainly technical changes or for compatibility.)

Read more >