Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Invalid SQL generated when using the json_object function #4770

Closed
ori-n opened this issue Feb 19, 2025 · 0 comments · Fixed by #4774
Closed

Invalid SQL generated when using the json_object function #4770

ori-n opened this issue Feb 19, 2025 · 0 comments · Fixed by #4774
Assignees

Comments

@ori-n
Copy link

ori-n commented Feb 19, 2025

I'm trying to generate SQL which uses the json_object function. I'm using sqlite dialect. I believe the issue is relevant for more dialects.

import sqlglot
sql = "SELECT json_object('id', 123, 'name', 'John')"
parsed = sqlglot.parse_one(sql)
print(parsed.sql()

The printed SQL doesn't run on sqlite, while the original statement runs as expected. This is the returned error:

sqlite3.OperationalError: unrecognized token: ":"

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants