JSON#
Querona supports JSON data natively — no additional driver is required.
JSON is a popular textual format for exchanging data in web and mobile applications, for log files, and in NoSQL databases; many REST services return or accept JSON. Querona lets you parse, query and produce JSON directly in T-SQL.
Working with JSON in SQL#
Test JSON text and extract scalar values, objects or arrays with ISJSON, JSON_VALUE and JSON_QUERY.
Format relational query results as JSON with
FOR JSON— see JSON.
See also#
JSON — the full JSON guide