Sqlmesh

:beetle: Bug fixes
* Typo (2140) serkef
* Track unknownModels to diff from CTEs (2141) mykalmax
* Defer unpausing right to right before env finalization when ensuring finalized snapshots (2147) izeigerman

:broom: Chore
* Update metrics docs tobymao

:sparkles: Features
* Add invalidate hard delete support to scd type 2 (2132) eakmanrq
* Keep track of the previous finalized snapshots in the environment (2130) izeigerman
* Ignore SQL model unit test row order unless query contains ORDER BY (2133) treysp
* Automatically create non-blocking copies of builtin audits (2136) vchan

:beetle: Bug fixes
* Motherduck only supports duckdb==0.9.2 (2134) treysp
* Lineage (2059) vchan
* Make sure that missing intervals don't exceed the target end date when applying plan (2142) izeigerman
* Make sure that builtin dbt macros can be referenced using the 'dbt.' prefix (2143) izeigerman

:broom: Chore
* Bump sqlglot to 21.1.1 (2135) georgesittas

:alien: Other
* Transpile default catalog for DuckDB test connection (2131) treysp

:sparkles: Features
* Include sqlmesh in version check (2125) eakmanrq

:beetle: Bug fixes
* Add missing tstz variable (2124) eakmanrq
* Add missing change categories (2126) mykalmax
* Use microsecond level precision for inclusive end dates (2128) tobymao
* Synchronize selected environment in all tabs (2127) mykalmax

:alien: Other
* Differentiate seed date and datetime types (2122) treysp

:sparkles: Features
* Allow configuring default formatting behavior in the UI via sql… (2064) z3z1ma
* Macro typing coercion (2041) z3z1ma
* Virtualized docs list, auto scroll to active item on refresh (2082) caiters
* Add dbt scd type 2 feature flag (2085) eakmanrq
* Add support for the synchronous mode to the 'invalidate' CLI command (2098) izeigerman
* Automatically compute previews for changed forward-only models in dev (2108) izeigerman
* Add SCD Type 2 Column Support (1997) eakmanrq
* Add tstz support (2121) eakmanrq

:beetle: Bug fixes
* Do not convert missing seed string column values to string (2086) treysp
* Show errors in preview only with lineage/table/diff (2083) mykalmax
* Slightly improve model autocompletion (2043) mykalmax
* Use correct root path when listing files with git (2087) izeigerman
* Clean up SourceList component (2092) mykalmax
* Improve perf by lazy loading models list (2094) mykalmax
* Add Go Back button to plan flow (2100) mykalmax
* Airflow use model name instead of snapshot name (2095) eakmanrq
* Select file and add tab we no tabs present (2096) mykalmax
* Set min-width for split panes (2097) mykalmax
* Control autocompletion manually (2099) mykalmax
* Have modules navigation in sidebar (2102) mykalmax
* Init bigquery with correct type (2110) eakmanrq
* When plan running dont error and just drop (2115) mykalmax
* Send message on plan cancel progress (2116) mykalmax
* Various clean ups (2114) mykalmax
* Styling (2118) mykalmax
* Support a missing value for an explicitly provided 'vars' key (2117) izeigerman
* Use space instead of T for timestamp format (2119) eakmanrq
* Improve lineage flow (2062) mykalmax

:broom: Chore
* Add a unit test for the git selector expressions izeigerman
* Add airflow test to develop doc (2090) eakmanrq
* Bump sqlglot to v21.0.0 (2101) georgesittas
* Use node for name instead of model (2105) eakmanrq
* Scope log handlers to modules (2106) eakmanrq
* Fix pydantic 1 support with new type (2111) eakmanrq
* Test CLI plan/run commands (2091) treysp
* Bump dev dbt duckdb (2123) eakmanrq

:alien: Other
* Add comment registration default arg to configuration reference (2088) treysp
* Revert "Feat: Macro typing coercion (2041)" (2089) eakmanrq
* Ibis example project (2084) andrew-sha
* Update README.md (2103) tobymao
* Update LICENSE (2104) tobymao
* Improve configuration guide environment view schema and catalog (2120) treysp

:beetle: Bug fixes
* Use correct root path when listing files with git (2087) izeigerman

:sparkles: Features
* Format slack messages in all cases (2058) plaflamme
* Support default catalog overrides in the Airflow scheduler config (1985) izeigerman
* Add support for MotherDuck (2067) izeigerman
* Make editor inspector collapsable on click (2018) mykalmax
* Extend selector with ability to select models that are different from the git main branch (2078) izeigerman

:beetle: Bug fixes
* Bring nodes forward on lineage (2057) mykalmax
* Remove pydantic 2.6 restriction (2049) eakmanrq
* Exclude non-model references from the selector's output (2068) izeigerman
* Protected against invalid backfill model names in the plan builder izeigerman
* Do not include a schema def in CTAS unless all column types are known (2063) treysp
* Display all values from deleted rows (2042) mykalmax
* Tune-up editor typing ux (2034) mykalmax
* Order projections during insert overwrite when there WHERE clause is not present (2074) izeigerman
* Replace query unknown self-reference (2075) eakmanrq
* Display failed audit queries in the dialect of the engine adapter (2077) vchan
* Rearrange to fix race condition when selecting tab from selected file (2076) mykalmax
* Improve plan flow transitions (2040) mykalmax
* Add quotes to delete expired snapshots (2080) tobymao
* Increase ttl for the cache snapshot records fetched from state sync (2081) izeigerman

:broom: Chore
* Update the selector integration tests to include unchanged upstream models (2065) izeigerman
* Remove command from slack notification (2073) vchan
* Upgrade black and mypy (2079) tobymao

:alien: Other
* Use parentheses for arrays in MODEL DDL (2052) treysp
* Add invalidate to CLI reference page (2069) treysp
* Add motherduck integrations page to mkdocs config (2072) treysp
* Expand external model documentation (2066) treysp