Sqlmesh

:sparkles: Features
* Allow disabling Trino SSL verification (2793) treysp
* Make SchemaDiffer precision aware (2768) treysp
* Support custom materialization strategies (2796) izeigerman
* Support token authentication for Airflow REST API (2798) izeigerman
* Enable dbt transpilation (2806) treysp

:beetle: Bug fixes
* Shortcuts and some styling for editor (2783) mykalmax
* Add a string representation for the Metadata change category (2797) izeigerman
* Truncate backfill models and adjust threshold (2794) Themiscodes
* Use isEmpty() for non pandas dataframes (2802) georgesittas
* Another snowflake staged file path edge case (2803) georgesittas
* Handle Paren in value or tuple validator (2804) georgesittas
* Dont set LIMIT 0 in nested queries that are part of a recursive CTE when generating a CTAS query (2800) izeigerman
* Support Airflow URLs without trailing slashes (2808) izeigerman
* Move away from the local custom-materializations dependency to unblock the release (2814) izeigerman
* Check all dialects used in a project when retrieving a model by its name (2801) izeigerman

:hammer_and_wrench: Refactor
* Error when trying to construct source queries from empty DFs (2795) georgesittas

:broom: Chore
* Bump sqlglot to v25.3.0 (2805) georgesittas

:alien: Other
* Add custom materializations guide (2807) izeigerman

:beetle: Bug fixes
* Add a string representation for the Metadata change category (2797) izeigerman

:sparkles: Features
* Remove distinct and use filter on right join (2763) eakmanrq
* Gateway-specific external models (2746) erindru
* Add environment migration progress bar (2772) Themiscodes
* Support 'enabled' flag in model definitions (2776) izeigerman
* Make sensor mode configurable for SQLMesh sensors in Airflow (2786) izeigerman
* Limit long lists of indirectly modified models in CLI output (2788) Themiscodes
* Allow overriding the dialects' normalization strategies (2779) georgesittas

:beetle: Bug fixes
* Start date for dev plans with enabled previews in which a new forward-only model has been added (2762) izeigerman
* Convert NaN/NaT (np.nan) values to None (2774) georgesittas
* Pass dialect to debug terminal console (2773) georgesittas
* Dry run for self-referencing model queries when creating a temp table during cloning (2771) izeigerman
* Emit warning when the seed table is not hydrated but the table exists izeigerman
* Redshift adapter can also use postgres adapter dispatch methods (2770) crericha
* Set the default model start when initializing a new project (2781) izeigerman
* Respect columns-to-types mapping provided by a user when replacing a table (2790) izeigerman
* Normalize default schema name when targeting prod too (2792) georgesittas

:hammer_and_wrench: Refactor
* Normalize environment names according to the engine's dialect (2722) georgesittas

:broom: Chore
* Remove snowpark dev dependency (2761) eakmanrq
* Bump sqlglot to 25.1.0 (2766) treysp
* Bump sqlglot to v25.2.0 (2778) georgesittas

:alien: Other
* Add mssql support for airflow (2767) simonprydden

:beetle: Bug fixes
* Add a string representation for the Metadata change category (2797) izeigerman

:beetle: Bug fixes
* Dry run for self-referencing model queries when creating a temp table during cloning (2771) izeigerman
* Emit warning when the seed table is not hydrated but the table exists izeigerman
* Redshift adapter can also use postgres adapter dispatch methods (2770) crericha
* Convert NaN/NaT (np.nan) values to None (2774) georgesittas
* Start date for dev plans with enabled previews in which a new forward-only model has been added (2762) izeigerman

:beetle: Bug fixes
* Add a category for metadata-only changes (2752) izeigerman
* Adding subquery udtf projections should be non-breaking (2754) tobymao
* Cicd bold verb like other bullet (2753) eakmanrq
* Deployability index calculation for forward-only models that have been already categorized (2757) izeigerman
* The broken reference check shouldn't check removed external models (2758) izeigerman
* Only report successful plan application when there's no exception (2759) izeigerman

:broom: Chore
* Simplify notification targets by removing notify decorator (2756) vchan