Sqlmesh

:sparkles: Features
* Support AzureSQL (3509) treysp
* Allow macro functions in when_matched property (3527) georgesittas
* Add this_model property in the macro evaluator to return a string (3528) georgesittas
* Support 'optimize' flag in model defs (3512) VaggelisD
* Add multiple catalogs functionality to MotherDuck connection (3484) naoyak
* Add support for auto-restatements (3529) izeigerman
* Exclusions in selector powered by full parsing (3535) tobymao
* Do recursive glob matching for ignore_patterns (3539) georgesittas
* Add ability to exclude dependencies in the requirements lock file (3544) izeigerman
* Improve message when no models are ready to run (3513) treysp
* Add support for merge_filter and dbt incremental_predicates for Incremental By Unique Key (3540) themisvaltinos

:beetle: Bug fixes
* Adapt evaluator test to prevent duplicate macro possibility (3520) themisvaltinos
* Propagate dialect to extract call for script loading (3521) georgesittas
* Include column descriptions in optimized query cache key (3532) georgesittas
* Reject string model names (3534) georgesittas
* Ensure that restatements in prod also trigger restatements in dev (3511) erindru
* A flaky auto-restatement test (3541) izeigerman
* Adapt evaluator test to use unique model names (3538) themisvaltinos

:hammer_and_wrench: Refactor
* Remove freezegun dependency in favor of time-machine (3533) georgesittas

:broom: Chore
* Switch tests from freezegun to time-machine (3516) treysp
* Add missing utc timezone to test (3526) eakmanrq
* Fix arg name in Node Field definition (3530) treysp
* Fix bigquery integration test (3536) georgesittas
* Fix tests that didnt work in non-UTC timezone (3542) erindru
* Remove deprecation warning from sushi (3543) tobymao

:alien: Other
* Check that test_adapter exist before closing (3518) Kayrnt

:beetle: Bug fixes
* Always treat forward-only models as non-deployable (3510) izeigerman

:sparkles: Features
* Add an option to pretty sql (3455) MikeWallis42
* **(cli)** Ability to set config CLI params via env vars (3493) kelsin
* Make log output more human-friendly (3496) plaflamme

:beetle: Bug fixes
* Always control error handling of audits in scheduler (3466) georgesittas
* **(athena)** Drop partitions in batches of 25 (3488) erindru
* Make `create_external_models` behave like other SQLMesh commands with respect to `--gateway` (3453) erindru
* Prevent unintentional table schema changes during evaluation (3487) izeigerman
* Make signals serializable (3480) tobymao
* Quote the table produced by _resolve_table (3494) georgesittas
* **(bigquery)** Pass catalog when checking for clustering key changes (3498) erindru

:hammer_and_wrench: Refactor
* Make when_matched syntax compatible with merge syntax (3497) georgesittas

:broom: Chore
* Move list of non-context commands to constant (3485) kelsin
* Bump sqlglot to v25.34.0 (3482) georgesittas
* Fix logger warning small typo (3489) themisvaltinos
* Fix faulty test (3490) erindru
* Address flaky Redshift test (3491) erindru
* Document clearing out history of scd type 2 model (3495) eakmanrq
* Cleanup tobymao
* Update readthedocs python from 3.8 to 3.10 (3504) treysp

:alien: Other
* Some tiny docs fixes as I find them (3483) djayatillake
* Cloud data catalog (3478) caiters
* Add Snowflake Tracking (3492) sungchun12
* Cloud overview page (3473) mesmith027
* Use image with white background on tcloud landing page (3499) treysp

:sparkles: Features
* Update CLI plan command's create environment message (3397) treysp

:beetle: Bug fixes
* Remove top level pyspark imports (3458) eakmanrq
* Apply cast-to-dcolon rule for every model statement (3463) georgesittas
* Consider sqlmesh major/minor for migrate and rollback (3446) MikeWallis42
* Use python 3.9 for airflow dockerfile template (3476) georgesittas
* UI task position (3470) MikeWallis42

:hammer_and_wrench: Refactor
* Move creation of snapshots into own method (3471) benfdking

:broom: Chore
* Deprecate python 3.8, use public API for magics arg parsing (3468) georgesittas
* Move model selection for runs into a separate method (3474) izeigerman

:alien: Other
* Tobiko Cloud Getting Started Docs (3424) sungchun12
* Evolve language to complement website (3467) sungchun12
* Debugger View Docs (3429) sungchun12

:beetle: Bug fixes
* **(bigquery)** Pass catalog when checking for clustering key changes (3498) erindru

:sparkles: Features
* Add multiple engine project support (3394) themisvaltinos

:beetle: Bug fixes
* Httpx usage for 0.28.0 (3440) erindru
* **(athena)** Fix error replacing partitions in Hive tables where the partition column is a date / timestamp type (3441) erindru
* Enable concurrency in DuckDB (3430) erindru
* Use string func in surrogate key macro (only md5 at the moment) (3448) georgesittas
* Use model dialect as fallback for audits (3447) georgesittas
* Store a Table in this_model var instead of its str representation (3457) georgesittas
* **(mysql)** Use LONGTEXT data type when storing large blobs of text (3442) MikeWallis42
* Import for workers (3454) mykalmax

:broom: Chore
* Fix typing and imports for ci/cd (3450) treysp

:alien: Other
* Add installation info to dbt quickstart (3449) treysp
* Fix ClickHouse capitalization (3452) treysp
* Tobiko cloud docs structure (3418) mesmith027