{
  "id": "enwiki-001323279488",
  "slug": "sql-2016",
  "title": "SQL:2016",
  "qid": "",
  "lead": "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. The standard consists of 9 parts which are described in some detail in SQL. The next version is SQL:2023.",
  "body": "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. 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. 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== ==References== ==External links== . ISO/IEC TR 19075-5:2016: Row Pattern Recognition in SQL ISO/IEC TR 19075-6:2017: SQL support for JavaScript Object Notation (JSON) ISO/IEC TR 19075-7:2017: Polymorphic table functions in SQL",
  "categories": [
    "10363121",
    "23204648",
    "23468805",
    "23603337",
    "26220375",
    "31128808",
    "31128809",
    "7386371"
  ],
  "license": "CC BY-SA 4.0",
  "source_uri": "https://en.wikipedia.org/w/index.php?oldid=1323279488",
  "content_hash": "",
  "created_at": null,
  "updated_at": 1763668052.0,
  "claims": [],
  "contradictions": [],
  "confidence": 0.6,
  "csl": {
    "id": "enwiki-001323279488",
    "type": "webpage",
    "title": "SQL:2016",
    "author": [
      {
        "family": "Anticloud FZ LLE",
        "literal": "Anticloud FZ LLE"
      }
    ],
    "container-title": "encyclopegia.org",
    "publisher": "Anticloud FZ LLE",
    "publisher-place": "Dubai, United Arab Emirates",
    "URL": "https://encyclopegia.org/a/sql-2016",
    "issued": {
      "date-parts": [
        [
          2026,
          11,
          18
        ]
      ]
    },
    "accessed": {
      "date-parts": [
        [
          2026,
          11,
          18
        ]
      ]
    },
    "license": "CC BY-SA 4.0",
    "DOI": "eo1:enwiki-001323279488",
    "isBasedOn": "https://en.wikipedia.org/w/index.php?oldid=1323279488",
    "note": "Immutable snapshot enwiki-001323279488"
  }
}