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