v1.10.1

[axellpadilla]

What's Changed

• (typo) Fix Spelling by @joshmarkovic in (typo) Fix Spelling #694
• feat: start v1.10.1rc1 by @axellpadilla in feat: start v1.10.1rc1 #700
• chore(deps): bump the github-actions-updates group across 1 directory with 2 updates by @dependabot[bot] in chore(deps): bump the github-actions-updates group across 1 directory with 2 updates #689
• fix to make drop_schema_name usable and test pass by @axellpadilla in fix to make drop_schema_name usable and test pass #563
• Feat/mssql python Add optional mssql-python backend and update docs / CI by @axellpadilla in Feat/mssql python Add optional mssql-python backend and update docs / CI #681
• Add implementation of persist_docs using extending properties by @semcha in Add implementation of persist_docs using extending properties #289
• chore: consolidate isort, flake8, pycln and absolufy-imports into ruff by @joshmarkovic in chore: consolidate isort, flake8, pycln and absolufy-imports into ruff #707
• Empty unit test fixtures (rows: []) emit invalid LIMIT 0 syntax by @Benjamin-Knight in Empty unit test fixtures (rows: []) emit invalid LIMIT 0 syntax #699
• chore(deps-dev): bump mypy from 1.11.2 to 2.1.0 in the pip-updates group across 1 directory by @dependabot[bot] in chore(deps-dev): bump mypy from 1.11.2 to 2.1.0 in the pip-updates group across 1 directory #691
• fix: guard run_hooks commit with @@trancount check for autocommit safety by @axellpadilla in fix: guard run_hooks commit with @@trancount check for autocommit safety #709
• Correctness fixes: LABEL escaping, dead columnstore guard, init port, misc by @joshmarkovic in Correctness fixes: LABEL escaping, dead columnstore guard, init port, misc #706
• Implement Postgres style index creation #535 Postgres style indexes by @Benjamin-Knight in #535 Postgres style indexes #714
• Implements dbt_sqlserver_use_dbt_transactions behavior flag by @axellpadilla in Implements dbt_sqlserver_use_dbt_transactions behavior flag #710
• Quick-win fixes: badge, exception type, is_integer, CI matrix, dead code by @joshmarkovic in Quick-win fixes: badge, exception type, is_integer, CI matrix, dead code #716
• Relocate SQLSERVER_TEST_DRIVER to setup_env.sh to comply with no spaces. by @axellpadilla in Relocate SQLSERVER_TEST_DRIVER to setup_env.sh to comply with no spaces. #722
• Use uv sync --all-extras and run instead of explicit pip install commands by @axellpadilla in Use uv sync --all-extras and run instead of explicit pip install commands #723
• feat: safe type expansion, NVARCHAR/NCHAR catalog fix, seed empty cell fix by @axellpadilla in feat: safe type expansion, NVARCHAR/NCHAR catalog fix, seed empty cell fix #702
• Add CHANGELOG entries for v1.10.1 release by @axellpadilla in Add CHANGELOG entries for v1.10.1 release #724
• docs: correct stale version, release, and CI references by @joshmarkovic in docs: correct stale version, release, and CI references #729
• feat: SQL Server 2025 support (plus as_columnstore docs and a store-failures regression test) by @joshmarkovic in feat: SQL Server 2025 support (plus as_columnstore docs and a store-failures regression test) #728
• chore(deps): bump actions/checkout from 6 to 7 in the github-actions-updates group by @dependabot[bot] in chore(deps): bump actions/checkout from 6 to 7 in the github-actions-updates group #727
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in [pre-commit.ci] pre-commit autoupdate #720
• Fix safe type expansion for incremental models by @axellpadilla in Fix safe type expansion for incremental models #731
• fix: honor configured query retries and correct the retry debug event by @joshmarkovic in fix: honor configured query retries and correct the retry debug event #730
• fix: escape embedded closing braces in pyodbc connection string values by @joshmarkovic in fix: escape embedded closing braces in pyodbc connection string values #734
• fix: make cancel() actually cancel the in-flight query by @joshmarkovic in fix: make cancel() actually cancel the in-flight query #733
• fix: STRING_AGG 8000-byte overflow in describe_indexes on wide tables (STRING_AGG 8000-byte overflow in sqlserver__describe_indexes breaks wide-table incremental/table/snapshot builds (1.10.1rc1) #735) by @joshmarkovic in fix: STRING_AGG 8000-byte overflow in describe_indexes on wide tables (#735) #739
• fix: don't aggregate columns for clustered columnstore indexes in describe_indexes by @Benjamin-Knight in fix: don't aggregate columns for clustered columnstore indexes in describe_indexes #745
• install dev group explicitly in setup_env by @Benjamin-Knight in install dev group explicitly in setup_env #748
• fix: emit query_options on table_refresh_method=dml refresh path by @Benjamin-Knight in fix: emit query_options on table_refresh_method=dml refresh path #753
• fix: report rows affected for incremental delete+insert by @axellpadilla in fix: report rows affected for incremental delete+insert #754
• chore: prepare 1.10.1 release by @axellpadilla in chore: prepare 1.10.1 release #755

My special thanks to all collaborators!

Full Changelog: v1.10.0...v1.10.1

---

This discussion was created from the release v1.10.1.