SQL:2023
 | This article, SQL:2023, has recently been created via the Articles for creation process. Please check to see if the reviewer has accidentally left this template after accepting the draft and take appropriate action as necessary.
Reviewer tools: Inform author |
| This article, SQL:2023, has recently been created via the Articles for creation process. Please check to see if the reviewer has accidentally left this template after accepting the draft and take appropriate action as necessary.
Reviewer tools: Inform author |
SQL:2023 or ISO/IEC 9075:2023 (under the general title "Information technology – Database languages – SQL") is the ninth revision 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
- 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)”, has been added to the SQL standard.
See also
References
- ^ "SQL:2023 is finished: Here is what's new". Retrieved 2023-06-01.
External links
- "SQL:2023", Catalogue (webshop), ISO.
 | This computing article is a stub. You can help Wikipedia by expanding it. |