Sqlmesh

:sparkles: Features
* Separate BQ user auth from account impersonation (3946) treysp
* Introduce Model linting (3787) VaggelisD

:beetle: Bug fixes
* Simplify the deployability index creation (3952) izeigerman
* State sync snapshot count() quoting (3954) erindru
* Batch intervals in DAG order to make sure that parent snapshot signals are respected by their children (3956) izeigerman

:broom: Chore
* Improve python model blueprint example docs (3948) georgesittas
* Bump sqlglot[rs] to v26.8.0 (3934) georgesittas
* Add Linter documentation (3950) VaggelisD

:alien: Other
* Query tables with limit 0 when retrieving schema for tables wit… (3935) lenare1K5
* Getting started tcloud docs (3942) afzaljasani

:sparkles: Features
* Add support for project before_all and after_all statements (3858) themisvaltinos
* BigQuery service account impersonation auth method (3940) treysp
* Enable INCREMENTAL_UNMANAGED models in native projects (3943) erindru
* Allow opting out of the time_column being automatically added to the partitioned_by columns (3941) erindru

:beetle: Bug fixes
* Make dialect regex more robust (3917) georgesittas
* Support custom dbt project loaders (3920) izeigerman
* Airflow warn instead of raise in get environment statements method (3922) themisvaltinos
* Fix ipython import for new versions (3927) benfdking
* Allow restatement of external models (3901) tobymao
* Fix logging, grain resolution and source/target object names in table_diff (3921) erindru
* Stop from get loaded context in async (3852) benfdking
* Selectively widen restatement intervals if they affect a downstream model that cannot be partially restated (3902) erindru
* Fix auth command (3938) afzaljasani
* Use the dialect when parsing the environment statements for the python_env (3939) themisvaltinos

:broom: Chore
* Improve error message when data type missing from column (3928) georgesittas
* Install extras modules before building API docs (3929) treysp
* Clarify user responsibility for key uniqueness in inc by unique key models (3930) treysp
* Show only one of direct/indirect/metadata update in console summary (3931) georgesittas
* Move removal of partial intervals out of the interval state and into the facade (3932) izeigerman
* Fix blueprint example in docs (3936) georgesittas

:alien: Other
* Improving executor (3924) benfdking
* Make relative paths absolute first in the models endpoint (3937) alucryd

:beetle: Bug fixes
* Batch intervals in DAG order to make sure that parent snapshot signals are respected by their children (3956) izeigerman

:beetle: Bug fixes
* Fix ipython import for new versions (3927) benfdking

:sparkles: Features
* **(BigQuery)** Add support for column descriptions in nested fields (3887) themisvaltinos

:beetle: Bug fixes
* Fix toggle indents (3918) sungchun12

:sparkles: Features
* Add risingwave engine adapter support for sqlmesh. (3436) lin0303-siyuan

:beetle: Bug fixes
* Use inspect.getsource in favor of custom parsing, stop relying on astor (3857) georgesittas
* Skip project loading when running the 'invalidate' CLI command (3910) izeigerman
* Take max interval end for a model into account even when there's a restatement interval (3913) izeigerman
* Airflow tests (3908) erindru
* Fix property audits_with_args in model definition.py (3904) blecourt-private

:alien: Other
* Break up the DB state sync (3903) izeigerman
* Add in SSO language for getting started page (3880) afzaljasani
* Revert "Fix!: use inspect.getsource in favor of custom parsing, stop relying on astor" (3909) georgesittas
* Easy to understand SQL Sequence for Popular Model Kinds (3907) sungchun12
* **(risingwave)** Update risingwave docs (3914) erindru