Format query results as JSON

Querona can return query results as JSON using the FOR JSON clause, just as SQL Server does. The guides in this section show how to shape that output — choosing AUTO or PATH mode, adding a root node, including null values, and removing the outer array wrapper.

• Add a Root Node to JSON Output with the ROOT Option
• Format Nested JSON Output with PATH Mode
• Format results as JSON with FOR JSON
• Format with AUTO Mode
• Include Null Values in JSON with the INCLUDE_NULL_VALUES Option
• Remove Square Brackets from JSON with the WITHOUT_ARRAY_WRAPPER Option