SQL:2023

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.

New features

SQL:2023 includes new and updated features. The changes can be grouped into three main areas:

Property Graph Queries (SQL/PGQ)

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.

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.

See also

References

  1. ↑ Eisentraut, Peter (4 April 2023). "SQL:2023 is finished: Here is what's new" (World wide web log). Retrieved 2024-11-08.
  2. ↑ "Database languages SQL — Part 16: Property Graph Queries (SQL/PGQ)". ISO/IEC 9075-16:2023 Information technology. ISO. 2023. Retrieved 2023-06-05.
  3. ↑ "SQL: 2023 is Released – A Leap Forward in Data Management". Stack diary. 1 June 2023. Archived from the original on 2023-06-02. Retrieved 2023-06-02.
  4. ↑ Eisentraut 2023.
  5. ↑ ten Wolde, Daniel; Singh, Tavneet; Szárnyas, Gábor; Boncz, Peter (8 January 2023). "DuckPGQ: Efficient property graph queries in an analytical RDBMS". IR. NL: CWI. Retrieved 2023-06-02.