Comments (1)
You need to specify the output dialect using either transpile or the sql method. Calling str on an ast implicitly generates towards the default sqlglot dialect which does not necessarily follow bq's syntax.
from sqlglot.
Related Issues (20)
- Regression in 25.1.0 when the write dialect is postgres and the read dialect is omitted HOT 1
- Snowflake Parser fails on columns called `case` HOT 2
- issue in transpile HOT 1
- Suppress errors HOT 1
- Snowflake: Select distinct off of a quoted column name without parenthesis doesn't parse correctly
- Transpiling `AT TIME ZONE` from redshift to bigquery HOT 2
- TSQL - ON in CREATE INDEX statements
- TSQL - Create Clustered/NonClustered Index
- Maybe Intersect and Except should not be Union Subclasses HOT 4
- MappingSchema _normalize can raise unclear "StopIteration" error if supplied schema dict has table with no columns
- Optimize does not consider AND condition properly inside an OR condition HOT 2
- Support nested Multiline comments
- SqlGlot crashes when parsing Redshift query, but successes if dialect is set to postgres.
- Sqlglot does not preserve new Databricks's Variant Syntax HOT 4
- Parse fails on Snowflake match_recognize() function (aslo exists in other dialects) HOT 1
- Inverting boolean filter with OR not retaining parenthesis on .sql() HOT 1
- Snowflake secure views creation sql fails to parse HOT 1
- Makes upper case last arg in Clickhouse date_sub func HOT 4
- sqlglot fails to parse BigQuery type cast
- bug in `nulls_first` default for oracle dialect.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from sqlglot.