Sqlmesh

:beetle: Bug fixes
* Place LIMIT before ORDER BY for UNION queries when generating a CTAS query (2277) izeigerman

:broom: Chore
* Isolate state sync cache (2274) eakmanrq
* Add pypirc command (2273) eakmanrq

:beetle: Bug fixes
* Improve performance of migration (2263) izeigerman
* Quote identifiers when deserializing model SQL attributes (2267) izeigerman

:broom: Chore
* Scale up slow tests (2268) eakmanrq
* Set airflow as library for some tests (2265) eakmanrq
* Publish sqlmesh tests (2270) eakmanrq
* Upgrade deps (2272) tobymao

:alien: Other
* Make user and pw fields optional for MSSQL connection (2262) treysp

:beetle: Bug fixes
* Optionally load context on models request (2224) mykalmax
* Fix UI quickstart plan flow (2259) treysp

:broom: Chore
* Remove fsspec dependency (2257) eakmanrq

:alien: Other
* Audits (2255) tobymao
* Disable bigquery table update metadata comparison for comments (2256) treysp
* Toby/revert types (2261) tobymao

:sparkles: Features
* Allow partial unit test expected column sets, improve error handling (2226) georgesittas
* Truncate comments to engine-specific maximum (2238) treysp
* Typed macros 2 (2109) z3z1ma

:beetle: Bug fixes
* Recursively check for unknown data types (2235) eakmanrq
* Redshift explain verbose no where limit (2239) izeigerman
* The default start value in the CICD bot config (2244) izeigerman
* Manual categorization (2197) mykalmax
* Improve error display for failed plan (2220) mykalmax
* List existing data objects concurrently when creating snapshot tables (2247) izeigerman
* Airflow local deployment for the most recent Docker version on Mac (2248) izeigerman
* Configure duckdb with connector_config settings. (2240) crericha
* Adding of LIMIT 0 to union queries when generating a model CTAS query (2250) izeigerman
* Warn instead of error single catalog multiple catalogs (2251) eakmanrq

:broom: Chore
* Update the default start value in the CICD bot docs (2246) izeigerman
* Serialize engine integration tests (2245) eakmanrq
* Fix ci/cd (2249) eakmanrq
* Bump sqlglot to v22.4.0 (2237) georgesittas
* Isolate web tests (2253) eakmanrq
* Cleanup tobymao
* Remove unused transactional file class (2254) eakmanrq

:alien: Other
* Return files even if there is no SQLMesh context (2230) vchan
* Add nesting level error to FAQ (2232) treysp
* Update UI quickstart to reflect UI updates (2234) treysp
* Expose additional fields in PlanDagSpec (2231) andrew-sha
* Fixing typo in default connection method (2243) kellydunn

:beetle: Bug fixes
* The default start value in the CICD bot config (2244) izeigerman

:sparkles: Features
* Use 1 thread for dbt duckdb targets (2222) treysp
* Allow setting register_comments for dbt connection (2212) treysp
* Add dbt trino support (2223) treysp

:beetle: Bug fixes
* Copy model's rendered query (2217) mykalmax
* Redshift non standard redshift plans with limits (2218) tobymao
* Support syntethic projections added to the plan by redshift (2225) izeigerman
* Never ignore forward-only snapshots when building a plan (2227) izeigerman
* Remove obsolete attributes from the Plan DAGs table (2229) izeigerman
* Default timeout -> 5 min (2228) mykalmax

:alien: Other
* Clarify which general properties apply to which model kinds in model config reference (2219) treysp
* Describe dbt/sqlmesh seed type inference and configuration (2221) treysp