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==