I tried to add sqlalchemy-stubs into my project and I experience problems with following construct:
db.execute(select(User).filter_by(id=user_id))
mypy error is:
error: "Select" has no attribute "filter_by" [attr-defined]
I've looked into sqlalchemy code and Select construct clearly has filter_by method.
I use Python 3.9.5 with sqlalchemy==1.4.41, mypy==0.990 and sqlalchemy-stubs==0.4.