SQL:2023

Uses your system voice; voice and rate in settings.

Snapshot

≈ 2 min read

Names in other languages

No names in other languages are held for this entry yet.

Article bodies are English and are not machine-translated. A name in another language is not a translation of the article.

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 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, a graph query language built on top of SQL The new part 16, “Property Graph Queries (SQL/PGQ)”, has been added to the SQL standard. New features related to JSON 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) 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 function (T056) Optional string types maximum length (T081) Enhanced cycle mark values (T133) ANY_VALUE (T626) Underscores in numeric literals (T662)

See also

SQL/PGQ Property Graph Query SQL:2023 reserved words

References

External links

. .

Text derived from https://en.wikipedia.org/w/index.php?oldid=1297361508 under CC BY-SA 4.0; modifications have been made.

Sources cited in this revision

4 named source(s) extracted from the cited revision. A source with no author is shown by its publication; nothing is invented.