You are viewing a plain text version of this content. The canonical link for it is here.
Posted to github@datafusion.apache.org by "lovasoa (via GitHub)" <gi...@apache.org> on 2024/11/08 11:33:38 UTC

[I] support for mssql `json_object` syntax [datafusion-sqlparser-rs]

lovasoa opened a new issue, #1506:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1506

   SQL server has a json_object function with a special syntax that uses colons instead of commas between json keys and values.
   
   ```sql
   SELECT JSON_OBJECT('name':'value', 'type':1)
   ```
   
   This is not yet supported in sqlparser. This would be useful in [SQLPage](https://sql-page.com) 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 :)


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [I] support for mssql `json_object` syntax [datafusion-sqlparser-rs]

Posted by "lovasoa (via GitHub)" <gi...@apache.org>.
lovasoa closed issue #1506: support for mssql `json_object` syntax 
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1506


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [I] support for mssql `json_object` syntax [datafusion-sqlparser-rs]

Posted by "lovasoa (via GitHub)" <gi...@apache.org>.
lovasoa commented on issue #1506:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1506#issuecomment-2496199367

   Fixed by @gaoqiangz . Thank you !


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org


Re: [I] support for mssql `json_object` syntax [datafusion-sqlparser-rs]

Posted by "gaoqiangz (via GitHub)" <gi...@apache.org>.
gaoqiangz commented on issue #1506:
URL: https://github.com/apache/datafusion-sqlparser-rs/issues/1506#issuecomment-2466067447

   👌 


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org


---------------------------------------------------------------------
To unsubscribe, e-mail: github-unsubscribe@datafusion.apache.org
For additional commands, e-mail: github-help@datafusion.apache.org