Complete SQLAlchemy inline pep484 typing

[CaselIT]

_{Status as of 2023-02}

Most of the library is typed, but some modules/packages that are still work in progress.

Modules / packages that still require work

• sqlalchemy.engine
  • cursor - passes omitting non-typed functions - internal module
  • default - passes omitting non-typed functions - internal module
• sqlalchemy.ext
  • declarative.extentions - missing most/all types - legacy
  • backed - missing most/all types - legacy
  • compiler - missing most/all types - popular api
  • indexable - missing most/all types
  • instrumentation - missing most/all types
  • orderinglist - missing most/all types
  • serializer - missing most/all types - legacy
• sqlalchemy.orm
  • bulk_persistence - missing most types - internal module
  • collections - missing most types - internal module
  • context - missing most types - internal module
  • dependency - missing most types - internal module
  • dynamic - missing most types - internal module
  • evaluator - missing most/all types - internal module
  • instrumentation - missing some types - internal module
  • loading - missing most types - internal module
  • persistence - missing most types - internal module
  • strategies - missing most types - internal module
  • strategies - missing most types - internal module
  • unitofwork - missing most types - internal module
  • util - missing most types - internal module
  • writeonly - missing most types - internal module
• sqlalchemy.sql
  • base - missing most types - internal module
  • compiler - missing most types - internal module
  • crud - missing most types - internal module
  • ddl - missing most types - internal module
  • functions - missing most types - internal module
  • lambdas - missing most types - internal module
  • naming - missing most types - internal module
  • roles - missing most types - internal module
  • traversals - missing most types - internal module
  • util - missing most types - internal module

[CaselIT]

We should try https://github.com/ambv/retype/

[sqla-tester]

Federico Caselli referenced this issue:

Properly type _generative https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/3423

[sqla-tester]

Mike Bayer has proposed a fix for this issue in the main branch:

initial reorganize for static typing https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/3447

[zzzeek]

related issues:

#7535
#7519
#7562
#7555

[zzzeek]

also there's the issue of replacing existing sqlalchemy-stubs packages in type checkers and it's suggested we use a "positive" masking approach, as a "negative" uninstall approach is not supported by type checkers that bundle the stubs: microsoft/pylance-release#840 (comment)

[sqla-tester]

Mike Bayer has proposed a fix for this issue in the main branch:

WIP for ORM typing https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/3495