SQL:2023 or ISO/IEC 9075:2023 (under the general title "Information technology – Database languages – SQL") is the ninth edition of the ISO (1987) and ANSI (1986) standard for the SQL database query language. It was formally adopted in June 2023.
SQL:2023 includes new and updated features. [1] The changes can be grouped into three main areas:
SQL/PGQ reduces the difference in functionality between relational DBMSs and native graph DBMSs. Basically, this new feature makes it easier to query data in tables as if it were in a graph database, providing a possibly more intuitive alternative to writing complex join queries. [4]
In comparison, the GQL standard for graph DBMSs adds graph updates, querying multiple graphs, and queries that return a graph result rather than a binding table. [5]
SQL:2023 or ISO/IEC 9075:2023 (under the general title "Information technology – Database languages – SQL") is the ninth edition of the ISO (1987) and ANSI (1986) standard for the SQL database query language. It was formally adopted in June 2023.
SQL:2023 includes new and updated features. [1] The changes can be grouped into three main areas:
SQL/PGQ reduces the difference in functionality between relational DBMSs and native graph DBMSs. Basically, this new feature makes it easier to query data in tables as if it were in a graph database, providing a possibly more intuitive alternative to writing complex join queries. [4]
In comparison, the GQL standard for graph DBMSs adds graph updates, querying multiple graphs, and queries that return a graph result rather than a binding table. [5]