We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
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
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: ":"
The text was updated successfully, but these errors were encountered:
geooo109
Successfully merging a pull request may close this issue.
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.
The printed SQL doesn't run on sqlite, while the original statement runs as expected. This is the returned error:
The text was updated successfully, but these errors were encountered: