Repository navigation
Open
Labels
EpicUse this tag to define an Issue as an Epic that contains multiple issues for a targetedUse this tag to define an Issue as an Epic that contains multiple issues for a targetedbig joba major change that requires a lot of knowledge and worka major change that requires a lot of knowledge and workcode review in progresscode has been provided that's in review as PR and/or gerritcode has been provided that's in review as PR and/or gerrithelp wantedExtra attention is neededExtra attention is neededtime consuming / tediousan issue that will take a long time to complete, even though it may be "easy"an issue that will take a long time to complete, even though it may be "easy"typingpep -484 typing issues. independent of "mypy"pep -484 typing issues. independent of "mypy"
Milestone
Description
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
-
Reacted by Thomas, Jo, mo, Marco Aguiar, parhammed, 塔奇巧克力, asomethings, li1234yun, Evan Huang, Alex Ted and 24 more
Reacted by Alex Ted and binbjz
Reacted by Alex Ted, Max and binbjz
Reacted by Đặng Minh Dũng, 塔奇巧克力, Alex Ted, binbjz, Niko Wilbert, James Braza and Artem
Reacted by Đặng Minh Dũng, 塔奇巧克力, Alex Ted, martín, binbjz and JD Solanki
Reacted by Alex Ted, JD Solanki and binbjz
Metadata
Metadata
Assignees
Labels
EpicUse this tag to define an Issue as an Epic that contains multiple issues for a targetedUse this tag to define an Issue as an Epic that contains multiple issues for a targetedbig joba major change that requires a lot of knowledge and worka major change that requires a lot of knowledge and workcode review in progresscode has been provided that's in review as PR and/or gerritcode has been provided that's in review as PR and/or gerrithelp wantedExtra attention is neededExtra attention is neededtime consuming / tediousan issue that will take a long time to complete, even though it may be "easy"an issue that will take a long time to complete, even though it may be "easy"typingpep -484 typing issues. independent of "mypy"pep -484 typing issues. independent of "mypy"
Activity
CaselIT commentedon Nov 22, 2021
We should try https://github.com/ambv/retype/
sqla-tester commentedon Dec 22, 2021
Federico Caselli referenced this issue:
Properly type _generative https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/3423
Properly type _generative, decorator, public_factory
sqla-tester commentedon Jan 6, 2022
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 commentedon Jan 9, 2022
related issues:
#7535
#7519
#7562
#7555
zzzeek commentedon Jan 9, 2022
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 commentedon Jan 9, 2022
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
108 remaining items
wip: Complete type annotations of engine.default module
kapildagur commentedon Aug 7, 2025
Hello @CaselIT ,
This weekend I'm planning for
sql.crudmodule, Plz ack me so that I'll plan my day...Thanks!
CaselIT commentedon Aug 7, 2025
ok!
type pysqlite
type pysqlite
Add type annotations to indexable extension code
Add type annotations to indexable extension code
sqla-tester commentedon Oct 8, 2025
Denis Laxalde referenced this issue:
Complete type annotations of sqlalchemy.engine.cursor module https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/6187
sqla-tester commentedon Oct 8, 2025
Denis Laxalde referenced this issue:
Complete type annotations of sqlalchemy.engine.cursor module https://gerrit.sqlalchemy.org/c/sqlalchemy/sqlalchemy/+/6192
Complete type annotations of sqlalchemy.engine.cursor module
Complete type annotations of sqlalchemy.engine.cursor module
Type postgresql.ExcludeConstraint()
Type postgresql.ExcludeConstraint()
Type postgresql.ExcludeConstraint()