v0.179.0

0.179.0 (2026-10-25)

⚠ BREAKING CHANGES

• sqb dbt run --json and sqb dbt build --json now fail with C238; use sqb dbt plan --json instead.
• Relative DuckDB and SQLite attach paths, including attach entries from a dbt profile, now resolve from the SQLBuild project directory instead of the working directory. Paths starting with ~/ resolve from HOME.
• On Snowflake, CONNECT_BY_ISLEAF and CONNECT_BY_ISCYCLE now raise E201, and a bare VALUES list as a CTE body, including in SQL-test fixtures, now fails with P001. Snowflake supports neither.

Features

• add a Postgres option to turn off temporary test functions (b91e2f3)

Bug Fixes

• compare scenario VARIANT and JSON columns by JSON value in local replay (b91e2f3)
• count Python checks in the build completion line, find mocked references on both sides of parenthesised joins, and support sqb mv with Python references (b91e2f3)
• keep make skills out of HOME (b91e2f3)
• map rule positions back through macro expansion (b91e2f3)
• match Snowflake star outputs against lowercase contract columns (b91e2f3)
• Polyglot star expansion with EXCLUDE, REPLACE and RENAME, column alias lists, Snowflake typed lambdas and subscript paths, nested set operation grouping, ClickHouse DATE_TRUNC and BigQuery RANGE types (b91e2f3)
• register DuckDB UDFs on every test connection and attach each database once (b91e2f3)
• reject --json on sqb dbt run and sqb dbt build (b91e2f3)
• reject Snowflake constructs Snowflake does not support (b91e2f3)
• resolve relative DuckDB and SQLite attach paths from the project directory (b91e2f3)
• SQL Server ISO cursor bounds, Databricks schema checks without a catalog, and ClickHouse line comments (b91e2f3)
• SQLite text timestamp cursors, temporal cast warnings, and dlt and ingestr loading (b91e2f3)