Sqlmesh

:beetle: Bug fixes
* Drop state tables during rollback when first migration fails (1484) vchan
* Commit transaction from pandas read sql query (1492) eakmanrq
* Fix scd type 2 replace query mixin (1491) eakmanrq
* Only use columns_to_types if annotated (1493) eakmanrq

:alien: Other
* Specify MIME types for javascript and css files (1490) vchan

:sparkles: Features
* Use the latest prod interval as an end date for dev plans (1480) izeigerman
* Support custom session properties in the Spark Submit Airflow operator (1482) izeigerman
* Support expressions when selecting models for restatement (1486) izeigerman

:beetle: Bug fixes
* Pin the snowflake connector dependency (1489) izeigerman
* Show column descriptions for unaliased columns in UI (1487) treysp
* Example project tobymao

:broom: Chore
* Fix build izeigerman
* Document the 'allow_partials' attribute in the model definition (1485) izeigerman
* Extend the docs for allow_partials izeigerman

:sparkles: Features
* Add more interval units and make the smallest 5 minutes (1471) tobymao

:beetle: Bug fixes
* Config hashing would break with bytes since it's not serializable (1481) tobymao

:broom: Chore
* **(docs)** Update interval unit tobymao

:sparkles: Features
* Skip croniter when possible for performance (1468) tobymao
* Allow evaluation of partial intervals (1451) izeigerman

:beetle: Bug fixes
* Ignore partial intervals when adding intervals to a snapshot (1466) izeigerman
* Fix : Restore selected env from local storage + add pinned envs to local list (1469) mykalmax
* Remove postgres materialized view support (1475) eakmanrq
* Move columns and rendered query to separate tabs in Editor inspector (1477) mykalmax
* Replace lock icon , relax zoom effect on lineage (1476) mykalmax
* Support standalone audits in the Airflow DAG generator izeigerman
* 1435 introduced invalid sql for querying the state sync (1479) tobymao

:broom: Chore
* Add custom pydantic types (1460) eakmanrq
* Update sqlglot to 18.7.0 tobymao
* Fix tests tobymao
* Update the Airflow end-to-end test izeigerman
* Cleanup github cicd bot tests (1470) eakmanrq
* Fix types (1478) tobymao

:alien: Other
* Add missing model config keys (1463) treysp

:beetle: Bug fixes
* Ensure overridden parser methods are called with the appropriate args (1459) GeorgeSittas
* Fix returning multiple values section in macro docs (1461) treysp

:broom: Chore
* Bump sqlglot to 18.6.0 (1462) izeigerman

:beetle: Bug fixes
* **(mssql)** Enable core functionality (1435) treysp
* Fix config ref connection titles (1455) treysp
* Properly validate scd type 2 fields (1456) eakmanrq

:broom: Chore
* Add materialized view test (1453) eakmanrq