SQLAlchemy release notes for 2022¶
This article contains the release notes for the SQLAlchemy, including the following when applicable:
Customer-facing bug fixes
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.
Version 1.4.4 (November 16, 2022)¶
Fixed a bug where percent signs (%) in a non-compiled statement should not be interpolated with empty sequence when executed.
Version 1.4.3 (October 21, 2022)¶
Fixed an issue
SnowflakeDialect.denormalize_namecould not handle empty strings.
Fixed a compatibility issue to vendor function
sqlalchemy.engine.url._rfc_1738_quoteas it is removed from SQLAlchemy v1.4.42.
Version 1.4.1 (August 23, 2022)¶
Fixed an issue where DATE was incorrectly removed from
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
Version 1.4.0 (July 21, 2022)¶
Added support for
Added support for Identity Column.
Added support for handling literal values for the sql types:
Numeric; also added support for converting the values into corresponding Python objects.
Added support for
Fixed a bug where insert with
autoincrementfailed 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.