0.22.1 (2026-11-19)
- databricks: keep a returned table's columns apart from their spacing (b0b1471)
- databricks: keep raw strings in path keys and resources (f20770d)
- duckdb: a NATURAL join of sides sharing no column is an error (f676760)
- semantics: a join condition reads only the items its engine lets it see (59eee86)
- semantics: a merged join key is ambiguous beside another item's column on PostgreSQL and SQLite (1491c39)
- semantics: check a named window's frame offsets as column references (5226ec6)
- semantics: find a named window in any case where names fold (922c838)
- semantics: hide a projection's own alias from the named window it reads (069484f)
- semantics: keep SQLite and BigQuery window keys from reading output aliases (d83c2c0)
- semantics: report an unknown base of a window an OVER reads (b04bf13)
- sqlite: a projection cannot read another projection's alias (ed2cee5)
- syntax: keep a window name's quotes in OVER and WINDOW (c418bc4)
- semantics: append a level's findings instead of extending with them (2d5c958)
- semantics: append a node's findings instead of extending with them (0a2ba35)
- semantics: collect a SELECT's scope once for its structure rules (2859752)
- semantics: hash scope-rule names with FxHash (5ffe07e)
- semantics: look an aggregate's name up in a set (d783426)
- semantics: normalise a single-spaced ASCII type spelling in one step (f9ad7cf)
- semantics: order findings without a position map when none needs one (d8a7ea5)
- semantics: read the family of a bare type word without allocating (8fbc3b7)
- semantics: record the lower analysis instruction count (3ce6c39)
- semantics: upper-case a Snowflake identifier in place (6395a1e)
- semantics: walk a node's children without collecting them first (edfdae5)
0.22.0 (2026-11-19)
- lint: lint now refuses a Postgres, BigQuery or Databricks statement whose tree nests past 512 levels, as Snowflake, DuckDB and SQLite already did, so 600 UNION ALL operands or 600
::casts no longer lint in those dialects. - keep each comma item's joins with it in Postgres, Databricks, DuckDB and SQL Server
- bigquery: sqlquack-syntax adds Literal::RawByteString and Literal::JoinedBytes, and GrantPrincipal gains a written field, so an exhaustive match on Literal or a GrantPrincipal struct literal no longer compiles.
- bigquery: keep a column's and a struct field's OPTIONS (563407d)
- bigquery: keep raw and adjacent pieces of bytes, typed literals and grantees (42ce043)
- keep each comma item's joins with it in Postgres, Databricks, DuckDB and SQL Server (65ef255)
- lint: a join inside UPDATE FROM never limits the write (2786df7)
- lint: add the call-depth note only to refusals of SQL that calls something (30b4ed0)
- lint: leave a fixture harness's empty relation out of the call depth (f5af215)
- lint: make max_function_call_depth the exact limit in every linted dialect (22a2a4c)
- lint: read cross joins and join keys inside FROM items (9db4571)
- lint: refuse native trees past the 512 depth ceiling, as the shared parser does (5c7768c)
- list a nested USING or NATURAL key once in a star (2ddd78a)
0.21.0 (2026-11-18)
- lint: take the function-call depth limit in parse_sql
- bigquery: the BigQuery parser now gives Literal::JoinedString, serialized as literal_type "joined_string" with the joined value and its pieces, for adjacent string literals, where it gave one Literal::String of the joined text.
- lint: take the function-call depth limit in parse_sql (4dd6098)
- bigquery: accept a grantee written as adjacent strings (714b00f)
- bigquery: keep the pieces of adjacent string literals (2cd6428)
- databricks: keep a function parameter's comment (999f5ed)
- databricks: keep only raw and adjacent credential values as written (62fa162)
- databricks: keep raw and adjacent credential values and raw typed literals (9d4a165)
- databricks: keep raw and adjacent spellings in plain-text string fields (b05cd31)
- lint: resolve a named window written after a parenthesized query (20f2974)
- semantics: check only the named windows an OVER reads (6e472d2)
- semantics: check the keys of a named window as column references (ffbf6f8)
- semantics: match a raw typed literal against its plain form when grouping (3c700d5)
- semantics: match grouping expressions whose strings are spelled differently (08c3ff8)
0.20.0 (2026-11-18)
- set the function-call depth limit at every parse entry point, up to 512 (bf55b2b)
0.19.0 (2026-11-18)
- databricks: sqlquack-syntax adds the Literal::JoinedString variant; code that matches Literal exhaustively must handle it.
- databricks: keep a written SELECT * FROM ( query ) apart from a pipe step's input (343c48a)
- databricks: keep an insert's parenthesised query apart from a bare one (ca4766f)
- databricks: keep raw and adjacent string spellings in trees (75f899a)
- databricks: keep WINDOW after a parenthesized query apart from WINDOW inside it (be79864)
- databricks: keep WINDOW after a parenthesized query apart from WINDOW over a star of it (b5a5cbe)
- databricks: refuse a TIMESTAMP with both WITHOUT and WITH LOCAL TIME ZONE (933d416)
- databricks: type a raw string literal as STRING (b860d19)
- semantics: check a join written in parentheses as a bare join (c07b62c)
- semantics: check USING beside a parenthesised join against its own sides (6225fbe)
0.18.2 (2026-11-18)
- snowflake: refuse a bare ALTER instead of panicking (57e8722)
0.18.1 (2026-11-18)
- databricks: keep backquoted names, tag key spellings and credential value types in trees (3d42bc3)
- databricks: keep every pair of parentheses around a relation or a query (95cfa5c)
- lint: check CTEs of a parenthesized query or CTE body (dc288d1)
- semantics: resolve clauses after a parenthesized query in its scope (2744091)
0.18.0 (2026-11-18)
- syntax: serialised call trees carry set_quantifier in place of distinct.
- coverage: add the Databricks receipt referee and obligation tooling (d664bd7)
- coverage: catalogue Databricks SQL 2026.45 forms, obligations and cases (afab7da)
- coverage: screen approved forms for collapsed spellings and gate on it (d3edd9d)
- databricks: parse documented Databricks SQL into trees that keep what was written (80e56ab)
- syntax: record a call's set quantifier, keeping an explicit ALL (9863126)
- convert: count rows for COUNT(*) under any quantifier but DISTINCT (5377ca7)
- databricks: keep the formatter and lint refusing forms whose trees are not reviewed (fb82b0a)
- website: show the current Snowflake syntax figure and fail CI when it drifts (28dab7b)
0.17.0 (2026-11-16)
- syntax: keep the FROM in Snowflake's DATE_PART ( part FROM value ) (5df8007)
- syntax: type Snowflake's TABLE ( ... ) arguments of data metric functions (b31c298)
- snowflake: keep a stage's PATTERN and DIRECTORY's stage as written (776ddfd)
- snowflake: keep an external table column's NOT NULL and quoted stage (a3821b0)
- snowflake: keep AT, BEFORE and CHANGES after a FROM call (f250959)
- snowflake: keep BY and = in ALTER SEQUENCE INCREMENT (203c8dd)
- snowflake: keep FORCE, ADD, WITH and OR REPLACE in table and index DDL (f789c72)
- snowflake: keep NOT ENFORCED after a foreign key's reference (0fec4c1)
- snowflake: keep the IDENTITY, START and GENERATED ALWAYS spellings of columns (b62c6f3)
- snowflake: keep the optional WITH before view policies and tags (6b38506)
- snowflake: label an online feature table's PRIMARY KEY (286d50c)
- snowflake: read // straight after a stage as its path (20f07ed)
- snowflake: read a model's quoted stage source as a stage reference (1b1edf9)
- snowflake: read event routing regions as strings and SHOW OPENFLOW DATA PLANE INTEGRATIONS LIKE (0d76ab1)
- snowflake: refuse a window name inside a semantic view metric window (b364ec6)
- snowflake: refuse UNSET values, a nameless SHOW PARAMETERS IN TABLE, MODIFY CONSTRAINT columns and a bare UNIQUE (83275ca)
- snowflake: tell LAST and LATEST deployments and IMPORTS aliases apart (8d69193)
- snowflake: type a view's RECURSIVE and scope and a materialization's REFRESH_MODE (ff178bc)
- snowflake: type ENABLE, DISABLE and VALIDATE constraint modifiers and keep inline ones (dde64db)
- snowflake: type SHOW SERVICES EXCLUDE JOBS and OF TYPE (b88a9a2)
- snowflake: type the out-of-line constraints of DEFINE, ICEBERG and DYNAMIC tables (fd26983)
- syntax-cases: continue a list whose first item is optional (a502766)
- syntax-receipts: classify four errno 1003 post-parse messages as semantic errors (303d389)
- tokenizer: end a stage at punctuation so a following // is still a comment (fdb054a)
0.16.1 (2026-11-15)
- ci: pin DuckShop's SQLBuild to the published 0.231.0 (d70daf2)
- format: indent a call's arguments under a line comment before the first one (30471a5)
- format: keep a call's argument indent after a comment between arguments (60450f9)
- receipts: classify 3 more reviewed post-parse Snowflake errnos as semantic (b143f0e)
- snowflake: give a dynamic table's secondary roles their own property (e7d8135)
- snowflake: keep a procedure's RETURNS TABLE columns as fields with their quoting (b93ecd9)
- snowflake: keep a table's policy, tag and column actions structured (729ec8a)
- snowflake: keep an anonymous procedure's options as properties (6f6611f)
- snowflake: read a MODIFY ( ... ) column list as typed column actions (f380256)
- snowflake: refuse nameless ALTER SET and UNSET that Snowflake refuses (737c81d)
- snowflake: set a constraint's options on their typed fields (6d8844c)
- syntax-cases: write a Snowflake keyword with a lower-case part instead of filling it (16441f7)
- syntax-cases: write an option of a branch that is one group of options (22beb13)
0.16.0 (2026-11-15)
- syntax-cases: give each option its own case when Snowflake refuses the case with every option (dd29423)
- syntax-cases: settle a documented observe case from its agreeing receipts (59523a0)
- syntax-coverage: accept receipts whose echoed locations were redacted, counted in locations_redacted (0af6b9e)
- receipts: classify 11 more reviewed post-parse Snowflake errnos as semantic (7a79c7e)
- receipts: classify 20 reviewed post-parse Snowflake errnos as semantic (95bbd31)
- snowflake: accept UNSET COMMENT when modifying an external consumer's token (e1b7851)
- snowflake: file a cortex search service's query under AS (3c78fb2)
- snowflake: keep a CREATE SNOWFLAKE class privilege's class path as a name (fcb06a7)
- snowflake: keep a routine's COPY = ( GRANTS ) as a keyword (deeefb7)
- snowflake: keep a storage location's option keys as keys (9d597e4)
- snowflake: keep AS on a RESAMPLE metadata column alias (62b46a3)
- snowflake: keep COLUMN and SET/DATA/TYPE words on an altered column (18da974)
- snowflake: keep how a temporary function was spelled (06bc929)
- snowflake: keep how a temporary procedure spells TEMP (b76b514)
- snowflake: keep the account of a DCM database definition (8a8918a)
- snowflake: key an ALTER option list's pairs by name (3d4866a)
- snowflake: parse an unquoted s3:// URL in ALTER STAGE SET URL (674b0ab)
- snowflake: read a group's object types as keywords (eec8538)
- snowflake: read a MATCH_RECOGNIZE pattern as a tree of variables, anchors, groups and quantifiers (c46fa19)
- snowflake: read documented property keywords as keywords (bdaca33)
- snowflake: refuse EXECUTE AS USER after another property in ALTER TASK SET (0e51c5b)
0.15.2 (2026-11-15)
- snowflake: accept a replica source that leaves out its account (e2627ac)
- snowflake: accept SET and UNSET on a named organization (f4eb433)
- snowflake: accept UNDROP VOLUME (19bd250)
- snowflake: keep a compute pool's STOP ALL OF TYPE as a property (6ee2777)
- snowflake: keep a data metric function's left-out column (d423774)
- snowflake: keep a data movement rule's row-limit return type (71f3d27)
- snowflake: keep a sequence's OR ALTER and optional words (5303167)
- snowflake: keep an account policy's FOR ALL scope as a property (e2d0cc9)
- snowflake: keep an ALTER action's own IF [ NOT ] EXISTS as a flag (025de45)
- snowflake: keep an application upgrade's PATCH as a property (01cac50)
- snowflake: keep FROM in model and specification create sources (578fbc5)
- snowflake: keep how a temporary table was spelled (eeee673)
- snowflake: keep KEY = value pairs in ALTER lists keyed (e9270c3)
- snowflake: keep PAT as written in token actions (527eb2f)
- snowflake: keep quoting and AS in MATCH_RECOGNIZE names (51b2bf4)
- snowflake: keep whether RUNTIME_VERSION and PACKAGES were written as strings (5b3b325)
- snowflake: label an Openflow connector's runtime and a runtime's deployment (1fe132d)
- snowflake: read a multi-word property value as a keyword phrase (1a0c294)
- snowflake: read CREATE ORGANIZATION <name> as an organization with properties (bbf26e5)
- snowflake: refuse FORCE before an account policy's FOR ALL scope (cff2aea)
0.15.1 (2026-11-15)
- syntax: accept function calls nested up to 256 deep (a236172)
- syntax: leave out a create's source when the statement names none (847e266)
0.15.0 (2026-11-15)
- syntax-coverage: audit forms without obligations and settle generated cases by their receipts (5df886e)
- syntax-coverage: count a refusal after parsing from a statement run without privileges (b7f1fad)
- syntax-coverage: count Snowflake's syntax error from a statement run without privileges (7a09b73)
- syntax: record Snowflake statements as structured trees that keep what was written (d758b8c)
- snowflake: accept an online feature table without a warehouse (71b1b61)
- snowflake: accept one string as a share's SET ACCOUNTS (8444210)
- snowflake: read CREATE OPENFLOW CONNECTOR, DEPLOYMENT and RUNTIME as trees (af5807f)
- snowflake: read DROP ACCOUNT with its grace period and DROP MANAGED ACCOUNT (77c95de)
- snowflake: refuse a bare word where Snowflake takes only a string (d2087cd)
- snowflake: refuse a trailing comma in more lists Snowflake rejects (4b917b0)
- snowflake: refuse OR REPLACE with IF NOT EXISTS on warehouses (a1a8273)
- snowflake: refuse tags on CREATE OR ALTER SECRET and DEFINE SECRET (e717f7c)
- snowflake: reject a bare word in UNDROP IDENTIFIER( ) and stop emitting empty names (e267ab5)
- syntax-cases: settle observed cases from probe-role receipts under any setup (42222de)
- syntax-catalogue: type the committed catalogue file as tables of rows (b6aa931)
- syntax-receipts: read errno 90105, no current database, as a post-parse semantic error (36ad01f)
0.14.0 (2026-11-14)
- syntax-coverage: give each repeated Snowflake list item its own missing, class and wrong-kind obligations (c1bc963)
- snowflake: accept an extra semicolon after a block member (6ab4b43)
- snowflake: read a DEFINE TABLE reference without FOREIGN KEY (4716d40)
- snowflake: refuse a COPY query column that starts with a dot (019bcb7)
- snowflake: refuse a string after a comma in a group's name list (de82372)
- snowflake: refuse a trailing comma in lists Snowflake rejects (29076cb)
- snowflake: refuse DEFAULT on an untyped column (58306ca)
- snowflake: report ALTER WAREHOUSE parse errors instead of raw text (1f5a47d)
- snowflake: require a string key after a comma in header and secret maps (b51361d)
- statements: keep the empty part when keying a call that leaves out its schema (9688f25)
- syntax-coverage: fill the second list item after an optional first item, and drop the parenthesis of an elided group (76df2b1)
- syntax-coverage: keep a documented Snowflake refusal when a positive renders the same SQL (d839796)
- syntax-snowflake: parse a call that leaves out its schema as a qualified call (478d767)
- syntax-snowflake: represent the part a..b leaves out as null with a flag on its owner (9801e12)
0.13.0 (2026-11-14)
- snowflake: keep routine and task properties, WITH, FORCE, quoted UNSET names, contact purposes and grant targets as tree fields (cc0d126)
- snowflake: parse CREATE TASK, CREATE VARIABLE, CREATE TAG, CONNECTION, DCM PROJECT and ALTER WAREHOUSE into typed trees (cc0d126)
- syntax-coverage: classify Snowflake name, word, numeric and placeholder operands, each with a wrong-kind case (cc0d126)
- syntax-coverage: re-baseline Snowflake form coverage to 2,826 verified of 3,479 forms (from 2,730) (cc0d126)
- snowflake: match recorded verdicts for typed operands (63f2195)
- snowflake: record no name for an unnamed ALTER USER or ON ACCOUNT grant, and flag an access token's own IF [NOT] EXISTS (cc0d126)
- snowflake: refuse reserved words as INSERT, MERGE, LIKE, SET and UNSET names (cc0d126)
0.12.1 (2026-11-13)
- syntax-coverage: give numeric Snowflake operands a wrong-kind case (4c8dfa6)
- syntax: keep a SHOW DELEGATED AUTHORIZATIONS clause as its scope (fb725bf)
- syntax: match recorded Snowflake verdicts and keep SHOW, task and routine modifiers in the tree (d4ca770)
- syntax: match recorded Snowflake verdicts for listing filters, routine maps, Iceberg versions and partial CREATE kinds (3bd7322)
- syntax: match recorded Snowflake verdicts for numeric operands given a string (e8ab1f7)
- syntax: refuse a malformed CREATE INTERACTIVE WAREHOUSE and read MAX_STALENESS as a string (cfe1e85)
- syntax: structure a lone Snowflake table contact and read SNAPSHOT POLICY before SET as a snapshot name (721eb8f)
0.12.0 (2026-11-13)
- syntax: parse Snowflake EXECUTE IMMEDIATE into a structured node (5cfcbe0)
- syntax: check a CREATE VARIABLE's type, default and comment (66f09a0)
- syntax: check DESCRIBE FUNCTION TABLE arguments (f556c0f)
- syntax: check warehouse table lists, ABORT, unnamed actions and connector PUSH (f4ec2d3)
- syntax: follow the recorded RESULTSET, notebook name and SHOW SERVICES verdicts (f0799e7)
- syntax: read a lone APPLICATION, CLASS or grantee kind in Snowflake SHOW as a name (1c7b1bf)
- syntax: read a notebook named PROJECT with options and an unnamed ALTER WAREHOUSE IF EXISTS (908ad5b)
- syntax: read SHOW WITH PRIVILEGES as documented privileges (8565bf4)
- syntax: refuse CONTACT on an event table (de1fa67)
0.11.3 (2026-11-13)
- syntax-receipts: place errno 921 parse errors as syntax errors (e770e16)
- syntax-receipts: place errors that show Snowflake read an object statement as semantic (ecce335)
- syntax: accept documented EXECUTE IMMEDIATE sources and keep DEFINE in DEFINE text (4938fa7)
- syntax: check external agents, connector versions, root task lists and organization user groups (55b02e6)
- syntax: check SHOW SERVICES, service snapshots and DEFINE FILE FORMAT modifiers (50f569d)
- syntax: keep INCREMENT = to Snowflake and read SET INCREMENT as an integer (f2d1e81)
- syntax: need a user name to rename, enroll MFA, or set a user policy or tag (a2386f9)
- syntax: read ALTER DYNAMIC TABLE actions the way Snowflake records them (6a6e004)
- syntax: read ALTER SEQUENCE SET and the smallest sequence START (5516f15)
- syntax: read CREATE and ALTER POSTGRES INSTANCE as Snowflake does (94cc0c8)
- syntax: read dynamic table clones, SET and event routing rules as the probe batch recorded (5e87a78)
- syntax: read external consumers, AI functions, EXECUTE IMMEDIATE and DEFINE of tags, pipes and code bundles as Snowflake does (81d9549)
- syntax: read notebook projects, organization profiles and group name properties as Snowflake does (6559625)
- syntax: read Snowflake GRANT, REVOKE and SHOW GRANTS as Snowflake does (9e31fde)
- syntax: read the object statement shapes the probe batch settled (7d2a329)
0.11.2 (2026-11-13)
- syntax: accept DEFINE DATABASE and SCHEMA with properties (f8193fd)
- syntax: read CREATE and ALTER DATA MOVEMENT RULE as Snowflake does (71aaa30)
- syntax: read CREATE and DEFINE ALERT as Snowflake does (16d0f5e)
- syntax: read CREATE and DEFINE STREAMLIT as Snowflake does (02610d6)
- syntax: read CREATE BACKUP SET, SNAPSHOT SET and APPLICATION as Snowflake does (3457610)
- syntax: read CREATE CORTEX SEARCH SERVICE as Snowflake does (9f5f666)
- syntax: read CREATE EXTERNAL and ORGANIZATION LISTING as Snowflake does (cf25d86)
- syntax: read CREATE SERVICE and APPLICATION SERVICE as Snowflake does (d8725e4)
- syntax: read Snowflake procedure modes, handler words and scoped tables (e4b5543)
0.11.1 (2026-11-13)
- lint: read a FIRST or LAST join alias as the relation's alias (f009b82)
- syntax: accept an online feature table without TARGET_LAG or with IF NOT EXISTS (98e46f8)
- syntax: read ALTER and DROP MODEL monitor as a model named or qualified by monitor (8fe9485)
- syntax: record a SEMANTIC_VIEW that writes DIMENSIONS before METRICS or FACTS (8343a82)
- syntax: record a stage path as a stage reference, not a string (75399f2)
0.11.0 (2026-11-12)
- syntax: give nine Snowflake property-list CREATE kinds structured trees (351d2c2)
- syntax: accept a COPY FILES stage written as a string literal (1e89bad)
- syntax: end compute pool and artifact repository CREATEs at their tag list, and name RSS (dee1656)
- syntax: keep a parenthesized property list flat (a8db36d)
- syntax: keep FOR APPLICATION to compute pools, read CREATE MODEL monitor as a model, and refuse a job service option given on both sides of FROM (b2a8bc5)
- syntax: read a bare FIRST or LAST as a join alias, refuse FIRST ( x ) after an aliased table, and take job service options before FROM (925f2f7)
- syntax: record AS on a table alias only when the SQL writes it (6c2692b)
0.10.0 (2026-11-12)
- syntax: check the head and option lists of Snowflake statements kept as text (48f2895)
- syntax: name DELETE USING subqueries, semantic views and FIRST/LAST join aliases as what they are (506cc2e)
0.9.0 (2026-11-12)
- syntax: check Snowflake class instance commands against their grammar (8ace8c0)
- syntax: parse EXECUTE DCM PROJECT plan, deploy and preview (23aae47)
- syntax: keep DCM names and anonymous procedure return nullability in the tree (24c23aa)
- syntax: refuse a null-input clause on a Snowflake handler-language anonymous procedure (4e6a694)
0.8.0 (2026-11-12)
- syntax: build Snowflake semantic views as nodes (45d2ebb)
- syntax: check Snowflake ALTER VIEW properties against their grammar (ad4c296)
- syntax: check Snowflake streams against their grammar (2837449)
- syntax: check Snowflake views and materialized views against their grammar (bd58df1)
- semantics: give every select item its range through each dialect's strict parser (8e7bfdc)
- syntax: read a Snowflake view's column list after its properties (344755e)
- syntax: read every Snowflake stream option on every source (4bd716c)
- syntax: refuse Snowflake view shapes its receipts reject (6b23d65)
0.7.0 (2026-11-12)
- convert: run FULL JOIN USING after a JOIN without ON left to right (1cbc3bd)
- syntax-cases: render external table options and DCM environments as documented (dc5dd46)
0.6.0 (2026-11-12)
- 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)
- 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)
- semantics: map output ranges in ASCII SQL without scanning it (8a2ea92)
0.5.1 (2026-11-11)
- lint: stop panicking on a query that ends in FROM (4ae2e6a)
- semantics: accept LAG and LEAD with one or two arguments in DuckDB (6ba17ca)
- semantics: leave a DuckDB TIMESTAMP(p) cast untyped unless p is 6 (4f7b865)
- semantics: let a derived table inside a LATERAL subquery read enclosing items (f9bcb57)
- semantics: let a FROM item read only the items before it, and accept a DuckDB derived table without LATERAL that reads an earlier FROM item as implicitly lateral, as DuckDB runs it (aad9f8f)
- semantics: stop reading a lambda parameter as an ungrouped column, so lambdas in grouped queries are no longer rejected (226a3a8)
- semantics: type DuckDB JSON casts, to_json, AT TIME ZONE and TO_TIMESTAMP (e509581)
0.5.0 (2026-11-10)
- verify: reuse the judgements of unchanged cases and judge cases in parallel (3a0068f)
- lineage: give a merged column its strongest branch's transform kind (0a86a2d)
0.4.1 (2026-11-10)
- convert: divide wide decimals through one helper macro (3d7ce28)
0.4.0 (2026-11-10)
- config: split the user sqlquack.toml from the evidence policy
- config: split the user sqlquack.toml from the evidence policy (017327d)
- config: keep refusing a fact under --strict when [allow] refuses it (6fc9ba1)
- syntax: cap the token list a tokenize run reserves up front (f9f37b3)
0.3.0 (2026-11-10)
- census: --names is removed. Use --detailed for a named report and --anonymous for a report without names.
- census: the previous anonymous counts report moves behind --detailed. --names and --assume-supported now require --detailed, and the slowest-files list appears only in detailed mode. Census now exits 1 when any file is blocked.
- census: add --anonymous for a shareable counts-only report (f94b4d9)
- census: name the unknown relation in a name-resolution cause (c587e72)
- census: report a diagnostic for each blocked file (fbadd64)
- cli: explain known differences and list them or every code (9d62bf2)
- cli: plain-English diagnostics and a one-line summary of known differences (4758180)
- cli: quote the policy file's reason in --verbose known-difference warnings (c1ed980)
- policy: describe all 38 known differences in plain English (101b811)
- policy: describe known differences in plain English (c93f4ee)
- sqlserver: read FOR SYSTEM_TIME as the table's version, its bounds a constant or a variable as SQL Server requires (0b68995)
- sqlserver: read FOR XML, FOR JSON and FOR BROWSE, and lay out FOR XML and FOR JSON as SQLClean does (aa6da9b)
- sqlserver: read join hints, REMOTE only after INNER, and keep them in the join keyword when laying out (fd8b0eb)
- sqlserver: read table hints, with SQL Server's conflict rules and the hints a write target refuses (c24aa5d)
- sqlserver: read table variables as table sources and write targets, without the hints and samples SQL Server refuses them (2c93771)
- sqlserver: read TABLESAMPLE on a table name, after its alias and before its hints, as SQL Server does (c6bbd9c)
- census: keep model chaining opt-in (8c25d57)
- cli: mark differences the defaults allow only in part (eab0a1d)
- cli: say known difference in census, review and verify output (df82e77)
- convert: name the project's sqlquack.toml by its name, not its folder's path (affd49f)
- coverage: refuse cited translation cases whose path has an empty, . or .. part (4dfb5fc)
- diagnostics: say what must be true of the session, not how to change the setting (64166cc)
- diagnostics: show a known difference's fine and wrong cases as whole sentences (e87b620)
- distributions: compile DuckDB's ICU extension into every bundled build (5b4ee0f)
- distributions: compile DuckDB's json extension into every bundled build (267e0b9)
- distributions: keep DuckDB's compiled-in extensions in Linux links (f1cbdb6)
- distributions: name DuckDB's release version in builds from its sources (cae4c1c)
- cast a widened number literal to its wider DECIMAL only once (cfaa28d)
- semantics: analyse a statement's lineage and findings in one pass (4da19b0)
- semantics: cheaper per-level findings bookkeeping (5349692)
- semantics: read a level's output aliases without copying them per projection (6be2847)
- semantics: read each Snowflake type spelling once per thread (7013ca5)
- semantics: reuse a level's FROM items between resolution and findings (31c42e8)
- semantics: share a level's alias-free traces between resolution and findings (87786d3)
- semantics: share a resolved query's column list instead of copying it (6e0f593)
- syntax: box the star expression so every expression moves fewer bytes (c786e78)
- syntax: check strict coverage on the parser's own tokens (73a6fff)
- syntax: let dialect parsers inline token text reads (fe9a0ee)
- syntax: list children without tracking their paths (6c054a0)
- syntax: look Snowflake reserved words up instead of scanning the list (503ecee)
- syntax: read ASCII single-character tokens and identifier quotes from a table (754664d)
- syntax: reserve the token list once per tokenize run (2096c69)