SQL server has a json_object function with a special syntax that uses colons instead of commas between json keys and values.
SELECT JSON_OBJECT('name':'value', 'type':1)
This is not yet supported in sqlparser. This would be useful in SQLPage where we use json for advanced features.
Reference: https://learn.microsoft.com/en-us/sql/t-sql/functions/json-object-transact-sql?view=sql-server-ver16
@gaoqiangz this may be of interest to you :)