SQLAlchemy release notes for 2022¶

This article contains the release notes for the SQLAlchemy, including the following when applicable:

Snowflake uses semantic versioning for SQLAlchemy updates.

Version 1.4.5 (December 9, 2022)¶

Updated the application name for the driver connection from SnowflakeConnection to SnowflakeSQLAlchemy.

Fixed a bug where percent signs (%) in a non-compiled statement should not be interpolated with empty sequence when executed.

Fixed an issue whereSnowflakeDialect.normalize_name and SnowflakeDialect.denormalize_name could not handle empty strings.
Fixed a compatibility issue to vendor function sqlalchemy.engine.url._rfc_1738_quote as it is removed from SQLAlchemy v1.4.42.

Fixed an issue where DATE was incorrectly removed from SnowflakeDialect.ischema_names.
Fixed breaking changes introduced in release 1.4.0 that:
- Changed the behavior of processing numeric, datetime, and timestamp values returned from service.
- Changed the sequence order of primary/foreign keys in list returned by inspect.get_foreign_keys and inspect.get_pk_constraint.

Added support for regexp_match and regexp_replace in sqlalchemy.sql.expression.ColumnOperators.
Added support for Identity Column.
Added support for handling literal values for the sql types: Date, DateTime, Time, Float, and Numeric; also added support for converting the values into corresponding Python objects.
Added support for get_sequence_names in SnowflakeDialect.

Fixed a bug where insert with autoincrement failed due to incompatible column type affinity.
Fixed a bug when creating a column with sequence, default value was set incorrectly.
Fixed a bug that identifier having percents in a compiled statement was not interpolated.
Fixed a bug when visiting sequence value from another schema, the sequence name is not formatted with the schema name.
Fixed a bug where the sequence order of columns were not maintained when retrieving primary keys and foreign keys for a table.