1.JSON

JSON -  JavaScript Object Notation - From SQL 2016

-          https://docs.microsoft.com/en-us/sql/relational-databases/json/json-path-expressions-sql-server?view=sql-server-2017

-          JSAN needs compatibility level 130 otherwise it will not work

-          Data, [Type], Value

-          lax and strict JSON Path modes in Sql Server 2016.  Strict is good to know the exact error

-          Functions : JSON_VALUE, JSON_QUERY, JSON_MODIFY, ISJSON and OPENJSON  / FOR JSON functions

-          FOR JSON PATH, WITHOUT_ARRAY

MyDoc