1.18.3

Released: January 29, 2026

bug

• [bug] [autogenerate] Fixed regression in version 1.18.0 due to #1771 where autogenerate
  would raise NoReferencedTableError when a foreign key constraint
  referenced a table that was not part of the initial table load, including
  tables filtered out by the
  EnvironmentContext.configure.include_name callable or tables
  in remote schemas that were not included in the initial reflection run.

  The change in #1771 was a performance optimization that eliminated
  additional reflection queries for tables that were only referenced by
  foreign keys but not explicitly included in the main reflection run.
  However, this optimization inadvertently removed the creation of
  Table objects for these referenced tables, causing autogenerate
  to fail when processing foreign key constraints that pointed to them.

  The fix creates placeholder Table objects for foreign key targets
  that are not reflected, allowing the autogenerate comparison to proceed
  without error while maintaining the performance improvement from
  #1771. When multiple foreign keys reference different columns in
  the same filtered table, the placeholder table accumulates all necessary
  columns. These placeholder tables may be visible when using the
  EnvironmentContext.configure.include_object callable to
  inspect ForeignKeyConstraint objects; they will have the name,
  schema and basic column information for the relevant columns present.

  References: #1787

• [bug] [general] Fixed regression caused by #1669 which requires SQLAlchemy objects
  to support generic type subscripting; for the older SQLAlchemy 1.4 series,
  this requires version 1.4.23. Changed the minimum requirements to require
  version 1.4.23 rather than 1.4.0.

  References: #1788