Sqlmesh

:sparkles: Features
* Improve macros (953) tobymao
* Optional rendered query and columns-to-types mapping (996) izeigerman

:beetle: Bug fixes
* Render values stored in dbt variables before using them (992) izeigerman
* Skip validation of partition keys when there SELECT * in the rendered query (1000) izeigerman
* Pass engine adapter when deciding whether the view should be re-created izeigerman
* Correctly render non-string dbt variables (1009) izeigerman
* Take the current package into account when trimming jinja macros (1010) izeigerman
* Extraction of variables that belong to the target package (1012) izeigerman
* **(macros)** Ensure FILTER condition is evaluated (1020) GeorgeSittas
* Allow SELECT * in models that reference external tables (1007) izeigerman

:hammer_and_wrench: Refactor
* Make macro evaluator a bit more efficient by not always parsing and reparsing (1002) tobymao

:broom: Chore
* Add a unit test for the models_exist API of State Sync izeigerman
* Bump sqlglot to v16.3.0 (1001) GeorgeSittas
* Fix mypy type hints in test_duckdb (1006) GeorgeSittas

:alien: Other
* Add %init magic (995) treysp
* Add ipywidgets to install_requires (997) treysp
* Update CLI reference doc (994) treysp
* Include columns used in on expression in response (1014) vchan
* Use global temp view (1017) eakmanrq
* Use latest sqlglot (1021) eakmanrq

:beetle: Bug fixes
* Handle empty models exists (993) tobymao

:sparkles: Features
* Greatly simplify table diff CLI invocation (977) z3z1ma
* Cache the optimized model query (975) izeigerman

:beetle: Bug fixes
* Hydrate seeds when fetching modified stored models (990) izeigerman

:broom: Chore
* Refactor the snapshot evaluator (982) izeigerman

:alien: Other
* Replace nan with None in table diff sample (987) vchan
* Make fetchdf notebook magic a cell magic (989) treysp
* Add build context to docker-compose.yml for the UI (991) vchan

:beetle: Bug fixes
* Convert seed's dataframe columns to the datetime object when their type is explicitly set to date / time (983) izeigerman
* Dont include model in metadata change if it in direct/indirect (985) mykalmax

:alien: Other
* Update config.yml (984) mykalmax

:sparkles: Features
* Introduce the table diff API endpoint (955) vchan

:beetle: Bug fixes
* Determine model dependencies after rendering. (972) crericha
* Path to the duckdb database file in the sushi example project izeigerman
* Fix table diff cli tobymao
* Make loading faster (974) tobymao
* Return None if renderered jinja is only whitespace (976) crericha
* Support dbt_utils.star except argument (973) crericha
* Backfilling batch size for seeds should always be None (979) izeigerman
* Various bugs (969) mykalmax
* Avoid duplicate subscription on component reuse (981) mykalmax

:broom: Chore
* Updated packages (978) mykalmax

:alien: Other
* Update quickstart (970) treysp
* Only run UI tests when UI files have changed. (980) vchan

:sparkles: Features
* Add spark connection config (945) eakmanrq
* Add support for materialzied views (951) izeigerman
* Introduce support for pre- and post- statements to seeds (956) izeigerman
* Extend SQL parser with designated blocks for jinja code (963) izeigerman

:beetle: Bug fixes
* Update join macro logic to match latest sqlglot changes (950) GeorgeSittas
* Use the '--version' argument instead of the 'version' command for printing the version in CLI (954) izeigerman
* Support sql_header config and config.set() jinja method for dbt projects. (952) crericha
* When evaluating a snapshot render pre- and post-statements right before their evaluation (961) izeigerman
* Support config() method in jinja. (962) crericha
* Unit test due to merging the stale branch izeigerman
* Redundant extraction of macro references in jinja expressions (965) izeigerman
* Invalidate the in-memory cache for the columns-to-types mapping when updating the model's schema (971) izeigerman

:broom: Chore
* Updated dbt comparison documentation to include new SQLMesh features. (946) crericha
* **(docs)** Fix typo in engine docs (958) GeorgeSittas
* Increate the no_output_timeout to 15m for the Airflow integration tests izeigerman
* Cosmetic fix izeigerman
* Bump sqlglot version (968) GeorgeSittas

:alien: Other
* Update airflow.md (947) serkef
* Use fixed dates for table diff test (949) vchan
* Add section for materialized views izeigerman
* Update engines.md (957) serkef
* Clarify Bigquery connection methods (959) eakmanrq
* Update redshift connection id to be consistent (960) eakmanrq
* Use dialect when creating table (966) eakmanrq
* Bump sqlglot (967) eakmanrq