Sqlmesh

:sparkles: Features
* Docs lineage for change categories (817) mykalmax

:beetle: Bug fixes
* Include source dependencies in depends_on for dbt models. (827) crericha
* Fix json encoding for models (828) vchan
* Pin dbt-duckdb version to avoid test failures izeigerman
* Replace exp.StructKwarg with exp.ColumnDef in schema diff (830) GeorgeSittas
* Improve the change categorization results by pre-matching root AST nodes (831) izeigerman
* Various bugs from file tree, editor, lineage, docs (832) mykalmax
* Improve performance of get snapshots queries by using IN instead of AND/OR (820) crericha

:alien: Other
* Always redirect back to index.html (836) mykalmax

:sparkles: Features
* Add loading logging to dbt adapter (804) crericha
* Gateway configuration BREAKING CHANGE (807) izeigerman
* Extend Airflow integration with the ability to provide an external DB connection for SQLMesh state (811) izeigerman
* Introduce logical merge for adapters that do not natively support merge (802) crericha
* BREAKING always parse macro returns as sql (815) tobymao
* Add Github Actions CI/CD Bot (810) eakmanrq
* Set up Docs (801) mykalmax
* Log exception stack traces from executor tasks to API console (825) vchan
* Use dbt manifest to load dbt projects (821) izeigerman

:beetle: Bug fixes
* In Postgres engine adapter only commit if there's no active transaction (800) izeigerman
* Pin ruamel.yaml version when running airflow tests on CircleCI izeigerman
* Data leakage was incorrect with window functions BREAKING CHANGE (805) tobymao
* Enforce unpaused parent snapshots only for new snapshots (809) izeigerman
* Don't add where false if no from statement tobymao
* Use package materialization config in dbt fixture (816) crericha
* Cnclude missing direct model names (822) mykalmax

:broom: Chore
* Upgrade sqlglot to 11.7 tobymao
* Upgrade sqlglot tobymao

:alien: Other
* Update uvicorn development server configs (806) vchan
* Continue watching even if context.load() fails, e.g. typos in a model file (808) vchan
* Format code (812) cornzyblack
* Update engines.md (813) wseaton
* Remove unneeded expand tobymao
* Improve BigQuery Pandas Implementation (814) eakmanrq
* Add missing import (823) eakmanrq

:sparkles: Features
* Introduce LLM integration (799) izeigerman

:beetle: Bug fixes
* Make start_date an actual date and add start_dt tobymao

:beetle: Bug fixes
* Remove overlapping intervals in old snapshots superseded by a new unpaused snapshot with the effective date set (788) izeigerman
* Normalize macro names tobymao
* Merge should use columns_to_types, so it can support pandas dfs (792) crericha
* DataFrame Where Clause Quoting (793) eakmanrq

:hammer_and_wrench: Refactor
* Print rendered dag location in terminal (789) cornzyblack

:broom: Chore
* Add redshift profile to dbt example project (791) crericha
* Bump sqlglot to v11.6.3 (795) GeorgeSittas

:alien: Other
* Escape redshift (787) eakmanrq
* Improve documentation around the `batch_size` property (794) plaflamme
* Add the if macro. (796) tobymao

:sparkles: Features
* Add ability to set the effective date for forward-only snapshots (785) izeigerman

:beetle: Bug fixes
* For forward-only plans run backfill after promotion (774) izeigerman
* Display nodes more condensed, update connection on column name change (781) mykalmax
* Support dbt model jinja method, use dialect when parsing, catch duplicate key errors, and improve parse time for very large sql models (782) crericha
* When applying a forward-only plan in dev the backfill shoulde precede the promotion (786) izeigerman
* Handle no rows in versions table due to corruption tobymao
* Flaky test with new sqlglot. tobymao

:broom: Chore
* Upgrade to sqlglot 11.6 and clean up example project paths tobymao

:alien: Other
* Reset selected lineage columns on tab change (772) mykalmax
* Add Dataframe Merge Support (770) eakmanrq
* Remove self from depends_on (773) eakmanrq
* Use jinja2 loopcontrols extension (776) crericha
* Remove catalog/db from spark temp view (777) eakmanrq
* What does backfill mean? (778) foundinblank
* Modify quickstart project and add seed file (779) foundinblank
* Add model tags field (775) vchan
* Redshift config port can be a string in profiles.yml (784) crericha

:beetle: Bug fixes
* Caching of rendered dbt model configs by making the dependencies attribute public (768) izeigerman
* Don't validate on migration (771) tobymao