Sqlmesh

:sparkles: Features
* Add support for freezing time in unit tests (2362) georgesittas

:beetle: Bug fixes
* Don't warn about state (2371) eakmanrq
* Expand snowflake VIEW column comments and make comment default true (2369) treysp
* Top nav flashing (2326) mykalmax
* Some keyboard bindings (2334) mykalmax
* Send file updates for plan and lineage modules (2375) mykalmax
* Data hash values for the model kind (2376) izeigerman
* Handle maps during test generation (2364) vchan
* Only insert new seed rows during migration (2381) izeigerman
* Improve inference of upstream dependencies for python models (2377) izeigerman
* Normalize both lists and ndarrays when generating unit tests (2388) georgesittas
* Detection of broken model references when building a plan (2390) izeigerman

:broom: Chore
* Improve recommended state sync documentation (2367) eakmanrq
* Report success at the end of the run command (2374) izeigerman
* Make dbt scd type 2 test cicd only (2378) eakmanrq
* Bump sqlglot to v23.6.3 (2382) georgesittas
* Add a comment and an assert to test_broken_references to prevent future regressions izeigerman

:alien: Other
* Trigger renovate (2379) andrew-sha
* Revert "Chore!: bump sqlglot to v23.6.3 (2382)" (2387) georgesittas
* Update README.md (make email link a mailto) (2389) anentropic

:sparkles: Features
* Generate CTE fixtures too when using the create_test command (2353) georgesittas

:beetle: Bug fixes
* Don't load models if start is ahead of end (2368) eakmanrq

:broom: Chore
* Use constant for list of commands that skip loading models (2363) crericha
* Update CLI command reference (2365) georgesittas

:alien: Other
* Fix docs for dag CLI (2356) andrew-sha
* Add model DDL columns example (2366) treysp

:sparkles: Features
* Allow partial to be for every output in a test (2355) georgesittas
* A CLI command to print the name of the physical table for a model (2340) izeigerman
* Allow UNION macros as model queries (2361) georgesittas

:beetle: Bug fixes
* Handle nested arrays during test generation (2359) vchan
* fix checking missing intervals against model end dates (2358) eakmanrq

:alien: Other
* Only include commit subject in webhook (2360) andrew-sha

:beetle: Bug fixes
* In scd type 2 also make sure all columns are known (2349) eakmanrq
* Ensure start if using end (2347) eakmanrq
* Modify test webhook (2352) andrew-sha
* Fix typo in sqlmesh_macros.md (2354) damjad

:broom: Chore
* Cleanup dialect variable reuse (2350) eakmanrq
* Send build url in test webhook (2345) andrew-sha

:alien: Other
* Normalize array before timestamps during test creation (2351) vchan

:sparkles: Features
* Improve unit test failure reporting when rows are missing (2338) georgesittas
* Make cicd bot output verbose (2348) eakmanrq

:beetle: Bug fixes
* Include end in metadata hash (2344) eakmanrq
* Use a correct deoployability index when running the scheduler against non-prod environments (2343) izeigerman
* Fix time_data_type serialization/deserialization (2342) eakmanrq

:sparkles: Features
* Add support for YAML dictionaries in unit tests (MVP) (2264) georgesittas
* Support Trino Delta Lake connector (2330) treysp

:beetle: Bug fixes
* Create a temporary view to source the model schema instead of parsing the Redshift plan (2308) izeigerman
* Fix testing webhook parameters (2339) andrew-sha
* Include dialect when extracting macro references (2341) eakmanrq

:broom: Chore
* Update unit test docs, fix minor github ci/cd bot docs typos (2327) georgesittas

:alien: Other
* Add link to model config ref to model concepts overview (2333) treysp