One of the latest additions to the SQL language is the JSON features. This new group of features makes it easier to benefit from the advantages of storing certain types of unstructured and schema-less data like the JSON format in a very structured and relational way using SQL native functions. This allows for many things, such as applying integrity contraints on certain JSON fields contained in a JSON document, indexing certain JSON fields, easily converting and returning unstructured data into relational data and vice versa, and inserting or updating unstructured data by the means of the proven reliability of SQL transactions.
To fully appreciate this new group of features, let's insert some data into the test ...
