Sqlmesh

:sparkles: Features
* Use pre / post SQL statements instead of hooks (910) izeigerman
* Add depends_on_past through self-reference check support (Built-in only) (917) eakmanrq
* Display node for CTE (915) mykalmax
* Table-diff, easily diff two tables. (907) tobymao

:beetle: Bug fixes
* Fix SQLMesh macro doc list rendering (924) treysp
* Fix macro docs sub-list formatting (925) treysp
* Ensure dict lookup won't fail during validation (922) GeorgeSittas
* Wrap router in suspense (918) mykalmax
* Some minor styling bugs (927) mykalmax
* Make sure internal models are not accidentally converted to external ones (926) izeigerman

:broom: Chore
* Chore[docs]: Restructure macro docs (905) treysp
* Add external models to sushi project (898) tobymao

:alien: Other
* Update links to macro docs (923) treysp
* Update setup.py (929) jecolvin

:alien: Other
* Include a model's CTEs when testing one of its CTEs (920) vchan

:sparkles: Features
* Display error tag on top level (854) mykalmax

:beetle: Bug fixes
* Evaluate snapshots after pomoting the environment if the plan contains paused forward-only snapshots (912) izeigerman
* Update sys_path before loading models. (914) crericha
* Use dialect in column_to_types_ validator (913) GeorgeSittas
* Re-fetch model's lineage after change to models/columns in file (891) mykalmax

:beetle: Bug fixes
* Escape double quotes for strings in dbt test kwargs. (900) crericha
* Support columns for late-binding views in Redshift. (906) crericha

:broom: Chore
* Fix mypy type hints, function prototypes to get parity with sqlglot (901) GeorgeSittas
* Fix mypy issues, use _parse_table_parts instead of _parse_table (903) GeorgeSittas
* Small cleanup of dialect.py (909) GeorgeSittas

:beetle: Bug fixes
* External models hash and is_breaking (897) tobymao

:sparkles: Features
* Store snapshot intervals separately from snapshot payloads (865) izeigerman
* Convert dbt tests into SQLMesh audits (858) crericha
* Add Github Action Bot Deploy Command (868) eakmanrq
* Add Databricks Connect Support (860) eakmanrq

:beetle: Bug fixes
* Fix databricks freezing (875) eakmanrq
* Fix typos (878) treysp
* Docs semi colon tobymao
* Pint airflow-providers dependencies izeigerman
* Pin apache-airflow-providers-common-sql in the Airflow docker image izeigerman
* Render model / audit query when computing a snapshot fingerprint when using the native SQLMesh format (879) izeigerman
* Quote 0007 migration query because snapshot is a reserved word in Redshift. (886) crericha
* Allow create_external_models to run for projects with star projections and support dbt formatted projects. (880) crericha
* Derive the name of a snapshot's physical schema from its model's schema (885) izeigerman
* Skip model loading for migrate and rollback commands. (888) crericha
* Use the models' dialects in schema methods (889) GeorgeSittas
* Fix state sync rollback test case (894) vchan
* Alias queries even if not optimized (895) tobymao
* Concat Dataframes if insert overwrite (890) eakmanrq
* Use SUPPORTS_INSERT_OVERWRITE and cleanup (893) eakmanrq

:hammer_and_wrench: Refactor
* Refactor tests and introduce Python model tests (874) vchan

:broom: Chore
* Change dbt project status logging from info to debug (881) crericha
* Update error message and method docs (887) crericha
* Bump sqlglot to v14.0.0 (896) GeorgeSittas

:alien: Other
* Don't use bugged typing-extensions release (882) eakmanrq
* Use latest pyspark (883) eakmanrq
* Expand macro documentation (877) treysp