Sqlmesh

: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

:broom: Chore
* Add interval inclusive/exclusive method (2543) eakmanrq
* Make connection factory property with kwargs (2544) eakmanrq

:alien: Other
* Clarify macro function keyword args (2525) treysp
* Reenable private tests (2546) andrew-sha

:sparkles: Features
* Support `condition` argument in `forall` audit (2504) plaflamme
* Make star macro more flexible (2518) eakmanrq
* Vararg and kwarg macro defs closes 2484 (2520) tobymao
* Adds plan id to apply notifications (2523) isaiahgm

:beetle: Bug fixes
* Propagate table properties as options when creating views in BQ (2517) izeigerman
* Use more robust way of identifying std macros (2519) tobymao
* This_macro needs to be quoted (2526) tobymao
* Force-lowercase dialect names, normalize macro columns_to_types (2524) georgesittas
* Use parse_identifier instead of to_identifier for catalog in unit test (2529) georgesittas
* Remove batch_size lookback check (2532) eakmanrq
* Handle empty row edge case in unit tests (2531) georgesittas
* Pass variable overrides when parsing profiles and dbt_project yamls (2534) izeigerman
* Add implicit dialect to pydantic models in python (2527) tobymao
* Don't push seed records when migrating snapshot rows (2535) izeigerman
* Mssql integration tests (2536) tobymao
* Add model prop comments closes 2533 (2537) tobymao

:alien: Other
* Revert "Fix: Propagate table properties as options when creating views in BQ (2517)" tobymao
* Toby/typed macros (2511) tobymao
* Disable private tests temporarily (2521) andrew-sha

:beetle: Bug fixes
* Don't push seed records when migrating snapshot rows (2535) izeigerman