When using JSON with SQL Server, you can use the JSON_QUERY()
function to extract an object or an array from a JSON string.
To use this function, you provide the JSON expression as an argument. You can also provide a second (optional) argument to specify the object or array to extract.