SQL:2016
{{Short description|2016 edition of the SQL standard}}
{{SQL language revisions}}
{{about|the language standard|MS SQL 2016, the Microsoft product|SQL Server 2016}}
SQL:2016 or ISO/IEC 9075:2016 (under the general title "Information technology – Database languages – SQL") is the eighth revision of the ISO (1987) and ANSI (1986) standard for the SQL database query language. It was formally adopted in December 2016.{{cite web | url = https://www.iso.org/committee/45342/x/catalogue/p/1/u/0/w/0/d/0 | title = ISO/IEC 9075, 13249, and others| access-date=2017-03-15}} The standard consists of 9 parts which are described in some detail in SQL. The next version is SQL:2023.
New features
SQL:2016 introduced 44 new optional features.{{cite web | url = https://modern-sql.com/blog/2017-06/whats-new-in-sql-2016 | title = What's New in SQL:2016| access-date=2017-06-16}} 22 of them belong to the JSON functionality, ten more are related to polymorphic table functions. The additions to the standard include:
- JSON: Functions to create JSON documents, to access parts of JSON documents and to check whether a string contains valid JSON data
- Row Pattern Recognition: Matching a sequence of rows against a regular expression pattern
- Date and time formatting and parsing
- LISTAGG: A function to transform values from a group of rows into a delimited string
- Polymorphic table functions: table functions without predefined return type
- New data type DECFLOAT
See also
{{Wikibook|Structured Query Language}}
References
{{Reflist}}
External links
- {{Citation | url = https://www.iso.org/standard/63555.html | contribution = SQL:2016 | title = Catalogue | publisher = ISO | format = webshop}}.
- [http://standards.iso.org/ittf/PubliclyAvailableStandards/c065143_ISO_IEC_TR_19075-5_2016.zip ISO/IEC TR 19075-5:2016: Row Pattern Recognition in SQL]
- [http://standards.iso.org/ittf/PubliclyAvailableStandards/c067367_ISO_IEC_TR_19075-6_2017.zip ISO/IEC TR 19075-6:2017: SQL support for JavaScript Object Notation (JSON)]
- [http://standards.iso.org/ittf/PubliclyAvailableStandards/c069776_ISO_IEC_TR_19075-7_2017.zip ISO/IEC TR 19075-7:2017: Polymorphic table functions in SQL]
{{SQL}}
Category:Declarative programming languages
Category:Computer-related introductions in 2016
{{Compu-stub}}