Sqlmesh

:sparkles: Features
* Cache external models for faster loading (4029) tobymao
* Introduce `sqlmesh lint` command (4034) VaggelisD

:beetle: Bug fixes
* Pass dialect to annotate_types and simplify (4026) georgesittas
* Move linting from load to plan creation (4032) VaggelisD

:sparkles: Features
* Improve blueprint loading performance (4030) georgesittas
* **(dlt)** Add support for project generation in filesystem pipelines (4028) themisvaltinos

:beetle: Bug fixes
* Using empty set as a default argument value (4022) izeigerman
* Always support start_* / end_* macros in pre- / post- statements (4025) izeigerman
* Don't expand intervals when recording an empty backfill (4031) izeigerman

:alien: Other
* Document use of .env file in executors (4033) benfdking

:sparkles: Features
* Add second level of verbosity (3982) treysp

:beetle: Bug fixes
* Migration of indirect non-breaking views (4020) izeigerman
* Pass runtime_stage and engine_adapter in environment_statements (4021) themisvaltinos

:beetle: Bug fixes
* Only allow to increase precision of VARCHAR for redshift (4008) izeigerman
* Only construct snapshot mapping once when computing missing intervals and the earliest start date (4012) izeigerman

:broom: Chore
* Bump sqlglot to v26.11.1 (4009) georgesittas
* Remove dead line in selector (4011) VaggelisD

:sparkles: Features
* Add cron_tz to allow scheduling according to time zones (3987) tobymao
* Support dynamic blueprinting (3997) georgesittas

:beetle: Bug fixes
* Support on-virtual-update statements in sqlmesh format (3998) themisvaltinos
* Enable schema binding when creating views for queries with recursive CTEs in redshift (4006) izeigerman

:broom: Chore
* Port mypy config to pyproject.toml (3994) erindru
* Update the docs for the allow_partials attribute (3993) izeigerman
* Correct documentation for the self-hosted executors (3999) izeigerman
* Bump sqlglot to v26.11.0 (4007) georgesittas

:alien: Other
* Use table name reference directly instead of select * subquery … (3991) z3z1ma
* **(tcloud)** Update scheduler facade docs for OAuth (3992) erindru

:sparkles: Features
* Adds support for macros in model_defaults and conditional properties (3933) themisvaltinos
* **(dlt)** Add support to override the dlt pipelines directory (3984) themisvaltinos

:beetle: Bug fixes
* Fail the plan command if the selector expression doesn't return any models (3968) izeigerman
* Sqlmesh_tests package version (3971) erindru
* Direct breaking category should only impact direct children snapshot (3975) izeigerman
* Determine SnapshotTableInfo equality with fingerprint only (3980) treysp
* Resolution of this_model within macros of on_virtual_update (3962) themisvaltinos
* Handle duplicate model names across sql, python and external models (3945) lafirm
* Type inference for BQ engine adapter (3981) VaggelisD
* Rename slow -> cicd tests in circleci (3985) lafirm

:broom: Chore
* Move linter doc from concepts to guides (3958) treysp
* Fix linter guide nav (3959) treysp
* Remove private push snapshots on state sync (3960) eakmanrq
* Switch from setup.py to pyproject.toml (3953) erindru
* Fix links to linter guide (3974) treysp
* Bump sqlglot to v26.10.0 (3986) georgesittas
* Bump sqlglot to v26.10.1 (3989) georgesittas

:alien: Other
* [DOCS]: Observe plan updates (3911) mesmith027
* [DOCS]: Observability Model Freshness updates (3912) mesmith027
* [DOCS]: Observer Run updates (3919) mesmith027
* Add nomissingaudits rule (3967) sungchun12
* Add docs editing HOWTO (3973) treysp