v0.6.0

0.6.0 (2026-11-12)

Features

• convert: convert TOP and FETCH FIRST to LIMIT (b593f7e)
• convert: lay out DuckDB output and helper macros with the formatter (be7425b)
• convert: run JOIN without ON as a cross join and name more unaliased columns (8f02569)
• format: break wide window specifications and keep one-line clauses on their header (61e7a4e)
• format: give parenthesised groups that span lines their own lines (c8e14ba)
• format: keep token case on request and lay out converted DuckDB SQL (4637fde)
• semantics: give each output column its expression's byte range (f09d2e9)
• syntax: accept Snowflake's scoped and volatile temporary tables (8d5ba02)
• syntax: build Snowflake dynamic iceberg and interactive tables as nodes (ad40a47)
• syntax: build Snowflake table and view governance actions as nodes (b98b9a0)
• syntax: build Snowflake tables with policies as structured nodes (168431e)
• syntax: check Snowflake DCM table definitions against the table grammar (d88fa2f)
• syntax: check Snowflake event, event routing and online feature tables (2e21de6)
• syntax: check Snowflake hybrid table indexes (38ae49e)
• syntax: check Snowflake iceberg and dynamic tables against their grammar (498be3a)
• syntax: check Snowflake table search optimization targets (5ac49ea)
• syntax: parse Snowflake external tables into structured nodes (39207dd)
• syntax: parse Snowflake iceberg column type and write default actions (b2725c8)
• syntax: parse Snowflake iceberg partition evolution (1872de0)
• syntax: parse Snowflake table reclustering and iceberg refresh (7d42d8b)
• syntax: parse Snowflake's key and unnamed constraint drops and constraint renames (066cf8d)
• syntax: read several Snowflake table properties after one SET (d3523c7)
• syntax: read Snowflake ALTER TABLE ADD with the table grammar (5939f22)

Bug Fixes

• check: refuse == as Snowflake does, with a new SQ0206 (86e200b)
• diagnostics: keep node names and guessed aliases out of the unaliased column message (cd64a37)
• format: keep a sign touching a modulo, which DuckDB reads as one operator (50734ca)
• format: keep the extra indent of a tighter operator under a looser one (bab166c)
• semantics: leave every set operation's outputs without a range (23c1099)
• syntax-coverage: fail on a not-submitted entry whose case has a receipt (cde63cd)
• syntax-receipts: count a run-database packet's repeated template once (ee638f5)
• syntax-receipts: document the phase rules in order and keep timeouts refused (c3a5599)
• syntax-receipts: import execute runs that have no run database (01ace82)
• syntax-receipts: place replication not enabled for the account as semantic (e55255a)
• syntax-receipts: place reviewed errors whose message shows Snowflake parsed the statement (bcc7178)
• syntax-receipts: refuse a record whose connector failed before Snowflake answered (9b67a8b)
• syntax-receipts: refuse a run-database packet carrying another run's template (722d8b8)
• syntax: keep the parentheses of a set operation that starts a longer one (20078f8)
• syntax: keep the parse in parse_strict so the instruction guard counts it (4f5cdfa)
• syntax: keep the source range of Snowflake table column names (451032f)
• syntax: name what is missing when a statement ends where an expression belongs (b802ca9)
• syntax: parse keyword lambda parameters and nested parenthesised set operations (9e2b9b6)
• syntax: parse Snowflake timestamp conversions with no arguments (369de78)
• syntax: point a dangling operator before GROUP BY or ORDER BY at the clause (9d34f79)
• syntax: read every secondary role of a Snowflake dynamic table (b18355d)
• syntax: record a star's source range in a located parse (d91f489)
• syntax: refuse misplaced Snowflake table actions (fb4e866)
• syntax: require a value for every Snowflake session setting (32ddec1)

Performance Improvements

• semantics: map output ranges in ASCII SQL without scanning it (8a2ea92)