Sqlmesh

:beetle: Bug fixes
* Use correct root path when listing files with git (2087) izeigerman

:sparkles: Features
* Format slack messages in all cases (2058) plaflamme
* Support default catalog overrides in the Airflow scheduler config (1985) izeigerman
* Add support for MotherDuck (2067) izeigerman
* Make editor inspector collapsable on click (2018) mykalmax
* Extend selector with ability to select models that are different from the git main branch (2078) izeigerman

:beetle: Bug fixes
* Bring nodes forward on lineage (2057) mykalmax
* Remove pydantic 2.6 restriction (2049) eakmanrq
* Exclude non-model references from the selector's output (2068) izeigerman
* Protected against invalid backfill model names in the plan builder izeigerman
* Do not include a schema def in CTAS unless all column types are known (2063) treysp
* Display all values from deleted rows (2042) mykalmax
* Tune-up editor typing ux (2034) mykalmax
* Order projections during insert overwrite when there WHERE clause is not present (2074) izeigerman
* Replace query unknown self-reference (2075) eakmanrq
* Display failed audit queries in the dialect of the engine adapter (2077) vchan
* Rearrange to fix race condition when selecting tab from selected file (2076) mykalmax
* Improve plan flow transitions (2040) mykalmax
* Add quotes to delete expired snapshots (2080) tobymao
* Increase ttl for the cache snapshot records fetched from state sync (2081) izeigerman

:broom: Chore
* Update the selector integration tests to include unchanged upstream models (2065) izeigerman
* Remove command from slack notification (2073) vchan
* Upgrade black and mypy (2079) tobymao

:alien: Other
* Use parentheses for arrays in MODEL DDL (2052) treysp
* Add invalidate to CLI reference page (2069) treysp
* Add motherduck integrations page to mkdocs config (2072) treysp
* Expand external model documentation (2066) treysp

:beetle: Bug fixes
* Order projections during insert overwrite when there WHERE clause is not present (2074) izeigerman
* Do not include a schema def in CTAS unless all column types are known (2063) treysp

:beetle: Bug fixes
* Exclude non-model references from the selector's output (2068) izeigerman
* Protected against invalid backfill model names in the plan builder izeigerman

:sparkles: Features
* More configuration for format command (2048) z3z1ma

:beetle: Bug fixes
* Minor lineage search visual issues (2047) caiters
* Check existence of both dev and prod tables in the snapshot evaluator (2051) izeigerman

:alien: Other
* Add table property to allow databricks spaces in column names (2053) treysp
* Do not set audit descriptions field with file comment (2056) treysp

:sparkles: Features
* Register table and column comments with engine (1878) treysp
* "remember" last selected model from Docs and show on return (2000) mykalmax
* Fetch model's sql from API on demand (2002) mykalmax
* Add some animation to plan stages (1999) mykalmax
* Add a debugger friendly console mode (1995) z3z1ma
* Create snapshot tables on demand (2028) izeigerman

:beetle: Bug fixes
* Expand seed $root marker in constructor (1996) z3z1ma
* Fixing SQL for a model freezes in Docs (2003) mykalmax
* Allow other tables in sqlmesh state schema (2005) crericha
* Use snapshot names in scheduler dag generation for performance (2010) tobymao
* Have dbt bq use timestamp instead of datetime (2012) eakmanrq
* Install typing-extensions (2015) mykalmax
* Pydantic_core import error izeigerman
* Use the Pydantic V1 validator interop in the model kind validator izeigerman
* Use the Pydantic V1 validator interop in the model kind validator izeigerman
* Function signature of the model kind validator izeigerman
* Allow columns to types to have spaces (1974) tobymao
* Fix tests tobymao
* Child snapshot targeting a wrong parent forward-only snapshot table when the parent was created in dev and the child in prod (2019) izeigerman
* Various UI lineage issues (2017) vchan
* Adjustments to new layout based on feedback (2011) mykalmax
* Set warning when getting file content results in error (2020) mykalmax
* Model lineage section at smaller widths (2021) caiters
* Further improve performance of dag by introducing a dummy node (2022) tobymao
* Databricks get catalog unity exception (2027) eakmanrq
* Lookback always ignoring cron (2029) tobymao
* When deleting expired snapshots in janitor only fetch relevant snapshot records (2030) izeigerman
* Use Insert/Overwrite for Replace to Fix Dataframe Batching (2031) eakmanrq
* Fetch snapshot records on demand when generating Airflow dags (2032) izeigerman
* Bg for modal component disappear (2044) mykalmax
* Pydantic less than 2.6 (2045) eakmanrq
* Share duckdb adapter is overlapping data files (2039) eakmanrq
* Spark Create Table DDL WAP (2033) eakmanrq
* Context close on Create/Update/Delete operations (2038) eakmanrq
* Ignore private attributes doing equality pydantic (2035) eakmanrq
* Changing catalog env override existing catalog matches (2025) eakmanrq

:broom: Chore
* Pin pytest version (2036) eakmanrq
* Bump sqlglot to 20.11.0 (2046) izeigerman

:alien: Other
* New UI layout (modules) (1701) mykalmax
* Add CLI flag for logging to stdout (2001) treysp
* Update cli quickstart with new output (2007) treysp
* Fix macro docs callout (2008) z3z1ma