1.7.6

Released: February 1, 2022

usecase

• [usecase] [commands] Add a new command alembic ensure_version, which will ensure that the
  Alembic version table is present in the target database, but does not
  alter its contents. Pull request courtesy Kai Mueller.

  References: #964

bug

• [bug] [batch] [regression] Fixed regression where usage of a with_variant() datatype in
  conjunction with the existing_type option of op.alter_column()
  under batch mode would lead to an internal exception.

  References: #982

• [bug] [autogenerate] Implemented support for recognizing and rendering SQLAlchemy "variant"
  types going forward into SQLAlchemy 2.0, where the architecture of
  "variant" datatypes will be changing.

• [bug] [autogenerate] [mysql] Added a rule to the MySQL impl so that the translation between JSON /
  LONGTEXT is accommodated by autogenerate, treating LONGTEXT from the server
  as equivalent to an existing JSON in the model.

  References: #968

misc

• [mssql] Removed a warning raised by SQLAlchemy when dropping constraints
  on MSSQL regarding statement caching.