v1.10.0rc1

What's Changed

• Modernize packaging: migrate setup.py to PEP 621 pyproject.toml by @joshmarkovic in #645
• chore(dependabot): switch Dependabot to weekly and separate security by @axellpadilla in #666
• UV usage by @Benjamin-Knight in #668
• Update adapter to dbt 1.10. by @Benjamin-Knight in #669
• Fix snapshot meta column name overrides on second run (#639). by @Benjamin-Knight in #670
• Add opt-in native string type mappings via behaviour flag (#626). by @Benjamin-Knight in #671
• Add regression tests for connection-string port handling (#496). by @Benjamin-Knight in #672
• Add DML table refresh method for table materializations (#641). by @Benjamin-Knight in #673
• Add regression tests for limit handling in test SQL generation (#638). by @Benjamin-Knight in #675
• Fix CTE detection with comments (#621) by @Benjamin-Knight in #676
• Fix reserved-keyword quoting in table-create DROP VIEW (#619). by @Benjamin-Knight in #677
• Add TABLOCK hint to contract-enforced INSERT INTO (#640). by @Benjamin-Knight in #678
• [pre-commit.ci] pre-commit autoupdate by @pre-commit-ci[bot] in #412
• Update the catalog macros to support multiple databases by @Benjamin-Knight in #603
• Fix: Handle view materialization alterations by @axellpadilla in #610
• Fix: Update model constraints functional test expectation for SQL Server contract INSERT semantics by @axellpadilla in #684
• Feat: add default schema concatenation flag support and update documentation by @axellpadilla in #685
• Perf: make hot-path adapter catalog queries sargable by @joshmarkovic in #686
• Update dbt-core dependency version range by @axellpadilla in #690
• Add query_options model config for SQL Server OPTION clauses (#613). by @Benjamin-Knight in #674
• Update SQL server relations to not require an alias by @Benjamin-Knight in #604
• Test tablock and query options interaction by @Benjamin-Knight in #679
• Update changelog for v1.10.0 by @axellpadilla in #693
• Improve environment setup and update dependencies for v1.10.0 by @axellpadilla in #696

Full Changelog: v1.9.1...v1.10.0rc1