Did you know that SQL has built-in JSON functions? These can come in very handy!

Instead of creating a very complicated query that exports XML and then translate it to JSON through a third party, you can use the following JSON SQL functions to identify valid JSON strings, extract JSON values and more.

 Function   DescriptionISJSON 

Tests whether a string contains valid JSON.

 JSON_VALUE 

Extracts a scalar value from a JSON string.

 JSON_QUERY 

Extracts an object or an array from a JSON string.

 JSON_MODIFY 

Updates the value of a property in a JSON string and returns the updated JSON string.