DacFx
DacFx copied to clipboard
Add support for new syntax in JSON_OBJECT and JSON_ARRAY
Docs:
- JSON_OBJECT: https://learn.microsoft.com/en-us/sql/t-sql/functions/json-object-transact-sql?view=sql-server-ver16
- JSON_ARRAY: https://learn.microsoft.com/en-us/sql/t-sql/functions/json-array-transact-sql?view=sql-server-ver16
JSON_OBJECT has new key value pair syntax like this: <json_key_value> ::= json_key_name : value_expression
Both functions also have a new clause <json_null_clause>
that can be either NULL ON NULL
or ABSENT ON NULL