Sqlmesh

:sparkles: Features
* **(dlt)** Add support for generation of nested dlt tables (3547) themisvaltinos

:beetle: Bug fixes
* Remove os-specific strftime format character (3559) treysp
* Support nested variables in dbt projects (3569) izeigerman
* Show diff for metadata changes in the plan output (3574) izeigerman
* Always create views in the virtual layer for expired environments (3575) izeigerman
* Add adapters for commands that are not using the snapshot evaluator (3531) themisvaltinos
* Don't drop intervals in state when restating models in a dev environment (3580) izeigerman

:broom: Chore
* Deprecate pydantic v1 (3548) georgesittas
* Fix the lock file name in docs (3549) izeigerman
* Remove the unused variable in the run_merged_intervals method (3550) izeigerman
* Move application of pending restatement intervals into the Snapshot class (3551) izeigerman
* Disable date prompts by default when running the plan command (3568) izeigerman
* Fix the Airflow e2e test izeigerman
* Set run_on_deploy_to_prod to false by default for the CICD bot (3572) izeigerman

:alien: Other
* Update incremental by unique key docs with merge_filter (3560) themisvaltinos
* Add contribution commands for docs (3571) seanpwlms
* Minor updates (3570) seanpwlms

:broom: Chore
* Move application of pending restatement intervals into the Snapshot class (3551) izeigerman

: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