SQL JSON

JSON Viewer: http://jsonviewer.stack.hu/  /  https://codebeautify.org/jsonviewer  /          https://jsoneditoronline.org

JSON_QUERY

SQL:

SELECT PersonID,FullName, JSON_QUERY(CustomFields,'$.OtherLanguages') AS Languages FROM Application.People

 

-          Comments are not supported in JSON documents.

-          This decision was taken by its designer Douglas Crockford because  people were using them to hold parsing directives.

-          See its syntax diagram http://www.json.org/.