Release

• v2.0.0a0 (July 16, 2026)
  • Breaking change: drop SQLAlchemy 1.4 support. The dialect now requires SQLAlchemy>=2.0.0. Users still on SQLAlchemy 1.4 should pin to snowflake-sqlalchemy<2.0.0.
  • Breaking change: update supported Python versions to >=3.9, <=3.14.
  • Fix regexp_match and regexp_replace flags rendered as bound parameters instead of literal strings (#SNOW-3573046). Flags passed to ColumnElement.regexp_match(..., flags=...) and ColumnElement.regexp_replace(..., flags=...) were processed through the standard parameter pipeline, producing incorrect SQL. Flags are now rendered as inline string literals, matching Snowflake's expected REGEXP_LIKE(col, pattern, 'i') / REGEXP_REPLACE(col, pattern, replacement, 'i') syntax.

Release Notes