SQLAlchemy release notes for 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.

Improved reliability by always using context managers.

None.

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.