Repository Issue Activity (beta)

#7438 Sqlite ParseError: Invalid expression / Unexpected token. for WINDOW

#7548 ClickHouse dialect: SHOW and EXPLAIN parse as Command (fallback for unknown syntax)

#7637 Adding rich support/tree visualisation

#7634 Oracle concat operator (||) fails with spaces

#7632 `qualify` optimization rule does not expand `RETURNING *` for UPDATE, INSERT and DELETE queries

#7624 parse_one does not handle COLLATE inside complex types

#7427 Sqlite doesn't support ALTER TABLE

#7628 Fail to parse duckdb's `from-first` syntax with `pivot` and join in subquery

#7612 Postgres parsing falls back to command for `CREATE TYPE`

#7625 SQLite: Named CTE columns not preserved in SQL generation

#7604 sqlglot.lineage doesn't preserve the struct-field path on leaf nodes

#7607 Snowflake: pushdown_projections incorrectly removes column aliases before `object_construct(*)`

#7619 Missing functions from DuckDB parser

#7617 logic inconsistance for CTE name with column names in sqlite

#7596 Fail on duckdb's `FROM first` with joining subqueries

#7593 `pretty=True` reindents newlines inside quoted identifiers

#7587 [CLAUDE] annotate_types(dialect=...) is silently overridden by schema.dialect

#7589 Possible to add security scans?

#7581 Trino/Presto shouldn't replace "SUBSTR" with "SUBSTRING" for binary fields

#4904 Add Dremio dialect

#7582 sqlglot fails to parse queries using functions or LLMs via Vertex AI

#7576 Lacking support for Impala Dialect

#7566 WITH ORDINALITY AS t(col, ord) alias gains a duplicate ord column when an Unnest node is rendered more than once in a single Generator.sql() pass

#7556 Generator.generate for Oracle raises "Argument 'format' is not supported" for ToChar while ast.sql works

#7541 Optimizing LATERAL VIEW EXPLODE on ARRAY<STRUCT> returns OptimizeError on field access on the generated alias