Jump to content

SQL:2023

From Wikipedia, the free encyclopedia
This is an old revision of this page, as edited by Cedar101 (talk | contribs) at 08:14, 14 August 2023 (→See also: {{Wikibook|Structured Query Language}}). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

SQL:2023 or ISO/IEC 9075:2023 (under the general title "Information technology – Database languages – SQL") is the sixth 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.[1] The changes can be grouped into three main areas:

  • Various smaller changes to the existing SQL language (all optional features):
    • UNIQUE null treatment (F292)
    • ORDER BY in grouped table (F868)
    • GREATEST and LEAST (T054)
    • String padding functions (T055)
    • Multi-character TRIM functions (T056)
    • Optional string types maximum length (T081)
    • Enhanced cycle mark values (T133)
    • ANY_VALUE (T626)
    • Underscores in numeric literals (T662)
  • New features related to JSON[2]
    • JSON data type (T801)
    • Enhanced JSON data type (T802)
    • String-based JSON (T803)
    • Hex integer literals in SQL/JSON path language (T840)
    • SQL/JSON simplified accessor (T860–T864)
    • SQL/JSON item methods (T865–T878)
    • JSON comparison (T879–T882)
  • Property graph queries
    • The new part 16, “Property Graph Queries (SQL/PGQ)”,[3] has been added to the SQL standard.

Property Graph Queries (SQL/PGQ)

SQL/PGQ is a subset of the emerging GQL standard. Thus, SQL/PGQ further 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. This feature could be very welcome in the data science community.[4]

GQL will add graph updates, querying multiple graphs and queries that return a graph result, rather than a binding table.[5]

See also

Wikibooks has a book on the topic of: Structured Query Language

References

  1. ^ "SQL:2023 is finished: Here is what's new". 4 April 2023. Retrieved 2023-06-01.
  2. ^ "SQL: 2023 is Released – A Leap Forward in Data Management". 1 June 2023. Retrieved 2023-06-02.
  3. ^ "ISO/IEC 9075-16:2023 Information technology — Database languages SQL — Part 16: Property Graph Queries (SQL/PGQ)". Retrieved 2023-06-05.
  4. ^ "The SQL:2023 standard is finalized and delivered with new features for the JSON format, changes to the existing SQL language and queries on property graphs". 2 June 2023. Retrieved 2023-06-02.
  5. ^ ten Wolde, Daniel; Singh, Tavneet; Szárnyas, Gábor; Boncz, Peter (8 January 2023). "DuckPGQ: Efficient property graph queries in an analytical RDBMS". Retrieved 2023-06-02.
Stub icon

This computing article is a stub. You can help Wikipedia by expanding it.

Retrieved from "https://en.wikipedia.org/w/index.php?title=SQL:2023&oldid=1170304429"