JSON_VALUE(expression , path) -- extract a scalar value from a JSON string.
JSON_QUERY( expression [ , path ] ) -- Extracts an object or an array from a JSON string.
OPENJSON( jsonExpression [ , path ] ) -- table-value function that parses JSON text and returns objects and properties in JSON as ...