Issues

• Snowflake typed lambda argument shares one DataType node across all its casts

  tobymao/sqlglot#8777 · Filter by author olmaks opened on Oct 24, 2026

• postgres: TABLESPACE in CREATE TABLE / INDEX / MATERIALIZED VIEW and USING INDEX TABLESPACE after UNIQUE / PRIMARY KEY fall back to Command

  tobymao/sqlglot#8776 · Filter by author cmodiano opened on Oct 24, 2026

• SQLite: built-in functions are annotated as UNKNOWN (no typing module for SQLite)

  tobymao/sqlglot#8773 · Filter by author punit857 opened on Oct 24, 2026

• BigQuery: DAYOFWEEK from MySQL/Spark is generated as DAY_OF_WEEK, which BigQuery does not have

  tobymao/sqlglot#8767 · Filter by author JoeyTan21 opened on Oct 23, 2026
  1

• Snowflake untyped ARRAY/OBJECT transpile to invalid DuckDB types

  tobymao/sqlglot#8766 · Filter by author tylerjthomas9 opened on Oct 23, 2026

• unnest_subqueries produces wrong results for COALESCE(SUM(...), k) and for nullable CASE expressions containing COUNT

  tobymao/sqlglot#8752 · Filter by author wjjc1017 opened on Oct 23, 2026
  1

  

• eliminate_joins treats DISTINCT ON (other_col) as uniqueness of the projected column

  tobymao/sqlglot#8751 · Filter by author wjjc1017 opened on Oct 23, 2026
  1

  

• parsing bug with intersect, dialect: postgres

  tobymao/sqlglot#8390 · Filter by author laravioli opened on Sep 18, 2026
  1