Sqlmesh

:sparkles: Features
* Support model selection when constructing a plan (1335) izeigerman
* Support simple model selection expressions (1338) izeigerman
* Introduce support for MSSQL deschman

:hammer_and_wrench: Refactor
* Move project from snapshot to model/node (1345) tobymao
* Use a rewriter instead of a renderer for metrics (1340) tobymao

:broom: Chore
* Add documentation for the MSSQL connection config (1341) izeigerman

:sparkles: Features
* Allow python models to return SQL expressions (1317) GeorgeSittas

:beetle: Bug fixes
* Remove intervals instead missing intervals (1322) eakmanrq
* Add ignored snapshots for invalid start date (1324) eakmanrq

:broom: Chore
* Add dev publish command (1331) eakmanrq

:alien: Other
* Switch back to insert/overwrite for databricks (1327) eakmanrq
* Add cron default to configuration reference (1328) treysp
* Only show progress bar if snapshots to process (1330) treysp

:sparkles: Features
* Make all incremental models in a dbt project forward-only by default (1303) izeigerman
* Add model to promote (1292) eakmanrq

:beetle: Bug fixes
* Make file watcher ignore local db updates (1306) mykalmax
* Correctly check schema names when cleaning up (1304) eakmanrq
* Respect plan `include-unmodified` flag when no model changes (1296) treysp
* Display column description + display model references in docs (1305) mykalmax
* Remove debounce async (1308) mykalmax
* CLI table-diff styling (1313) treysp
* Table properties serde (1310) eakmanrq
* Styling updates for table and table-diff (1312) mykalmax
* Dbt-redshift 1.6 removed column class specialization (1320) crericha
* Format model on save (1309) mykalmax
* Use full file path to get model from path_to_model_mapping (1321) mykalmax
* Support latest Pydantic V2 version in tests (1325) izeigerman
* Fetch column types if the type is unknown for a partition column in the BQ engine adapter (1326) izeigerman

:broom: Chore
* Add the Delegating State Sync base class to simplify downstream implementations (1316) izeigerman

:alien: Other
* Update dbt docs with full list of unsupported jinja methods (1299) GeorgeSittas
* Add config link to state info question (1302) treysp
* Clean up audit in snapshot evaluator (1301) vchan
* Update table diff guide (1319) treysp
* Update configuration reference (1307) treysp

:sparkles: Features
* Add sqlmesh references and automatic joins (1278) tobymao
* Add ability to select node and build path from that node to current (1245) mykalmax
* Support Table Properties on Views (1286) eakmanrq
* Allow macro lambdas with expansion on tuples (1298) tobymao

:beetle: Bug fixes
* Improve interval_unit validation and support the field in dbt projects (1281) crericha
* Make Databricks use replace where (1291) eakmanrq
* Migration of grain tobymao
* Editor content updates too late with debounce mykalmax
* Set debounceImmediate to false for model lineage (1293) mykalmax
* Exclude redundant keys from the config attribute in dbt models (1294) izeigerman
* Support physical table schema override for dbt projects (1297) izeigerman

:broom: Chore
* Support Pydantic 2 (1290) izeigerman

:alien: Other
* Update engine integration docs (1288) treysp
* Strip trailing whitespace from docs (1289) treysp

:sparkles: Features
* Add column statistics to output and make sample opt in on cli (1265) z3z1ma
* Recreate a view if missing even if the rendered query hasn't changed (1268) izeigerman
* Table diff sample by row source (1272) treysp

:beetle: Bug fixes
* **(snowflake)** Extract date from datetime values, quote audit's this_model (1269) GeorgeSittas
* **(metrics)** Don't normalize metric names (1270) GeorgeSittas
* Remove debounce from initial request (1275) mykalmax
* Fix column stats display when no common columns (1279) treysp
* Resubscribe after new connection has beed established (1282) mykalmax
* Correctly recreate views for snapshots categorized as indirect non-breaking (1285) izeigerman

:broom: Chore
* Bump sqlglot to v17.10.2 (1276) GeorgeSittas

:alien: Other
* Add scheduling questions to FAQ (1267) treysp
* Add repo and social links mkdocs.yml (1271) SoumayaMauthoorMOJ
* Update table diff guide (1280) treysp
* Set immediate true for updating editor content (1283) mykalmax

:sparkles: Features
* Make default target environment configurable (1262) izeigerman
* Add ability to override the dbt target name in the SQLMesh config (1263) izeigerman
* Include Jinja macros when rendering a model definition (1264) izeigerman

:beetle: Bug fixes
* Rendering of a model definition with table properties specified (1261) izeigerman
* Fix!(tests): normalize identifiers according to the config's dialect (1206) GeorgeSittas
* Increase request timeout delay (1266) mykalmax
* Include catalog name in schema creation (1249) eakmanrq

:broom: Chore
* Add default_target_environment description to the configuration reference doc izeigerman

:alien: Other
* DRY up audit error messages and add model to audit result (1260) vchan