Sqlmesh

:beetle: Bug fixes
* Parsing of session properties when only one key-value pair is provided (2610) izeigerman

:broom: Chore
* Improve the error message for arguments that can't be resolved at parse time izeigerman

:beetle: Bug fixes
* Add runtime stage to jinja (2597) tobymao
* Ignore non-restateable models and print out a warning instead of failing the plan (2605) izeigerman
* Add support for untyped snowflake arrays (2608) eakmanrq

:broom: Chore
* Support dbt 1.8 (2594) tobymao
* Support dbt 1.8 (2601) izeigerman
* Cosmetic changes to how we resolve session properties for a model (2603) izeigerman

:alien: Other
* Add isolated systems guide (2541) treysp
* Add blue-green deployment (2595) treysp
* 2335 Add support for session properties in model defaults (2596) ciprian-cgr
* Update engines that support environment catalogs (2606) treysp
* Integrate table of contents into left navbar (2607) treysp

:beetle: Bug fixes
* Setuptools for tests (2593) tobymao

:sparkles: Features
* Add ability to override the engine adapter of a unit test (2553) georgesittas
* Provide helpful error for invalid model defaults keys (2564) treysp
* Add virtual_properties and rename table_properties to physical_properties (2561) Kayrnt
* Allow macro functions to be used as model meta properties (2574) georgesittas
* Allow user-supplied queries to generate unit test data (2579) georgesittas

:beetle: Bug fixes
* Track visited in cll to avoid infinite loop (2568) mykalmax
* Reset active nodes when changing model in lineage + show source on hover (2569) mykalmax
* Support missing parents when constructing the deployability index (2570) izeigerman
* Change databricks to replace where (2571) eakmanrq
* Prepend model name to CTE and derived table node names (2578) vchan
* Monospace `plan_id` (2583) plaflamme
* Limit the file name length for the cache entry in the dbt loader (2582) izeigerman
* Support macros when rendering dbt variables (2581) izeigerman
* Use spark 3.5.0 in the Airflow test image izeigerman
* Properly format regex (2586) tobymao
* Remove accidental pyspark dependency added in ruff refactor (2587) georgesittas
* Execution_time was not getting passed in from plan (2573) tobymao
* Remove write race conditions in cache operations (2592) eakmanrq

:broom: Chore
* Additional tests for lineage with derived tables (2545) vchan
* Add test for snowflake _df_to_source_queries USE SCHEMA calls (2562) crericha
* Update API documentation SQLMesh logo (2563) georgesittas
* Add documentation for new duckdb catalog options (2566) eakmanrq
* Bump sqlglot to v23.14.0 (2575) georgesittas
* Only warn about table_properties deprication when loading a model from the local file system izeigerman
* Upgrade and unpin deps to support python 3.12 (2572) tobymao
* Upgrade dev spark to fix integration tests (2580) tobymao
* Always use the view_properties argument when creating a view (2577) izeigerman
* Replace autoflake+black+isort with ruff (2584) georgesittas
* Fix build, ensure all dfs have unified date time types tobymao
* Format output tobymao
* Fix the Airflow tests by switching from table to view for raw.demographics izeigerman
* Fix tests izeigerman
* Move Docker related files for UI dev into web directory (2590) vchan
* Update sqlglot (2591) tobymao
* Bump tobymao

:alien: Other
* Feat: Full support for Duckdb attach options (2565) wseaton

:broom: Chore
* Upgrade sqlglot (2560) tobymao

:sparkles: Features
* model decorator `kind` arg should be passed a dict (2547) treysp
* Add RuntimeStage.TESTING (2557) georgesittas
* Allow := for audit kwargs for consistency (2558) tobymao

:beetle: Bug fixes
* Model kind change should not be categorized as forward-only (2551) izeigerman
* Format CAST as :: less aggressively (2555) georgesittas
* Dont normalize model meta and lower audit args tobymao
* Include catalog if available when calling USE SCHEMA in snowflake (2556) crericha

:alien: Other
* Improve error message when the parsing of 'cluster_by' / 'partition_by' fields fails in the dbt loader (2548) izeigerman
* Update docs to clarify multi repo support (2552) mpcarter
* Revert "fix!: dont normalize model meta and lower audit args" tobymao
* Reapply "fix!: dont normalize model meta and lower audit args" (2559) tobymao