sqlglot

sqlglot copied to clipboard

References: * https://clickhouse.com/docs/en/sql-reference/functions/date-time-functions#date_trunc * https://clickhouse.com/docs/en/sql-reference/aggregate-functions/reference/varsamp * https://clickhouse.com/docs/en/sql-reference/aggregate-functions/reference/stddevsamp

longxiaofei

[bug] When converting SQL statements from PostgreSQL (pgsql) to MySQL, there might be issues due to differences between the two database systems that can cause the converted statements to fail when executed

6

**Before you file an issue** - Make sure you specify the "read" dialect eg. `parse_one(sql, read="spark")` - Make sure you specify the "write" dialect eg. `ast.sql(dialect="duckdb")` - Check if the...

Toms1999

[bug] These conversions are consistent, but not consistent in meaning ， from pg to mysql

1

**Before you file an issue** - Make sure you specify the "read" dialect eg. `parse_one(sql, read="spark")` - Make sure you specify the "write" dialect eg. `ast.sql(dialect="duckdb")` - Check if the...

Toms1999

[bug] execute error when postgres to mysql

2

**Before you file an issue** - Make sure you specify the "read" dialect eg. `parse_one(sql, read="spark")` - Make sure you specify the "write" dialect eg. `ast.sql(dialect="duckdb")` - Check if the...

Toms1999

[bug] execute sql but parse error

1

**Before you file an issue** - Make sure you specify the "read" dialect eg. `parse_one(sql, read="spark")` - Make sure you specify the "write" dialect eg. `ast.sql(dialect="duckdb")` - Check if the...

Toms1999

Hi expert, I got a ParseError: ``` File "C:\Project\AIProjectLangfuse\.venv\Lib\site-packages\sqlglot\parser.py", line 1312, in raise_error raise error sqlglot.errors.ParseError: The number of provided arguments (10) is greater than the maximum number of supported...

xidian237

tobymao

feat(optimizer)!: Expand stars on BigQuery's tbl.struct_col.* selections

1

Fixes #3484 BigQuery supports star expansion such as `foo.bar.*` where `foo` is the table and `bar` is a struct. This is essentially a _flatten_ operation from the specified struct and...

VaggelisD

Snowflake Alter Table ... Add Column ... WITH TAG (...) doesn't parse correctly

1

**Before you file an issue** - Make sure you specify the "read" dialect eg. `parse_one(sql, read="spark")`: **snowflake** - Make sure you specify the "write" dialect eg. `ast.sql(dialect="duckdb")`: **snowflake** - Check...

barino86

Snowflake Alter Table ... Alter Column ... DROP NOT NULL doesn't parse correctly

6

**Before you file an issue** - Make sure you specify the "read" dialect eg. `parse_one(sql, read="spark")`: **snowflake** - Make sure you specify the "write" dialect eg. `ast.sql(dialect="duckdb")`: **snowflake** - Check...

barino86