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.
Tests whether a string contains valid JSON.
Extracts a scalar value from a JSON string.
Extracts an object or an array from a JSON string.
Updates the value of a property in a JSON string and returns the updated JSON string.
Visit the DevX Tip Bank