Sqlmesh

:sparkles: Features
* Add new table_format property alongside storage_format (3175) erindru
* Support column types for dbt seeds (3172) Themiscodes
* Bot commands that run a single step raise on failure (3195) eakmanrq

:beetle: Bug fixes
* Properly convert nested types to BQ schema (3185) plaflamme
* More perf by offloading mork work to cores (3189) tobymao
* **(bigquery)** Materialized views do not support column comments (3166) treysp
* Correctly use execution time on new rows for scd type 2 by column (3192) eakmanrq
* Invalidate the optimized query cache entry when a macro definition changes within the model model definition (3194) izeigerman
* **(bigquery)** Fix BQ materialized view column comments (3193) treysp

:broom: Chore
* Include MSSQL into the list of engines recommended for storing SQLMesh state (3183) izeigerman
* Reorganize engine adapter integration tests (3188) erindru
* Bump sqlglot to v25.24.0, exclude sqlglot.diff Keep nodes (3191) georgesittas

:alien: Other
* Support for BigQuery quota project (3182) Kayrnt
* Allow clickhouse connection pool (3187) ravenac95

:sparkles: Features
* Finalize clickhouse engine adapter (3125) treysp
* Add support for GCP postgres instance authentication using IAM with service account keyfile/keyfile json (3162) liaco
* Athena adapter (3154) erindru
* Allow formatter to use CAST over :: syntax (3173) georgesittas

:beetle: Bug fixes
* Take deployability into account when rendering a model's query with the 'render' command (3160) izeigerman
* Support all model methods in dbt projects (3161) tobymao
* Only limit the root node since bigquery can't handle too many limits tobymao
* Remove dependency on tenacity from Athena adapter (3169) erindru
* Regression caused by optionally normalizing identifiers in renderer (3165) georgesittas
* Fix columns-to-types when inserting by time partition if the type of the time column is unknown (3168) izeigerman
* Only load prod if multi repo is enabled (3170) tobymao
* Update _parse_table_parts to reflect latest sqlglot signature (3171) georgesittas
* Typing imports were not working (3176) tobymao

:hammer_and_wrench: Refactor
* Allow overriding is_breaking_change in categorize_change (3178) georgesittas

:broom: Chore
* Bump sqlglot to v25.22.0 (3156) erindru
* Remove incomplete & outdated commands from API overview doc page (3174) georgesittas

:alien: Other
* Add docs for xdb-diff (3137) erindru
* Fix gcp postgres docs page (3157) treysp
* Warn about concurrency with DuckDB as state db (3155) treysp
* Update this_model macro var description (3158) treysp
* Clarify how to set default table location for trino on aws glue (3159) treysp
* Revert "fix: only limit the root node since bigquery can't handle too many limits" tobymao
* Reapply "fix: only limit the root node since bigquery can't handle to… (3167) tobymao

:sparkles: Features
* Bot commands that run a single step raise on failure (3195) eakmanrq

:beetle: Bug fixes
* Fix columns-to-types when inserting by time partition if the type of the time column is unknown (3168) izeigerman

:alien: Other
* Reapply "fix: only limit the root node since bigquery can't handle to… (3167) tobymao

:beetle: Bug fixes
* Only set effective_from for evaluatable models (3153) izeigerman

:beetle: Bug fixes
* Avoid using model aliases to produce versioned model names when loading dbt projects (3150) izeigerman
* Support comments in Jinja queries coming from dbt models (3152) izeigerman