DacFx icon indicating copy to clipboard operation
DacFx copied to clipboard

Add support for new syntax in JSON_OBJECT and JSON_ARRAY

Open zijchen opened this issue 1 year ago • 0 comments

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

zijchen avatar Sep 28 '22 15:09 zijchen