Cannot access member "add" for type "AsyncSession" (pylance) SQLAlchemy 1.4

[jacksbox]

Describe the bug

I'm using VSCode with pylance and sqlalchmey=1.4.32.

If I try to use the add() method of the AsyncSession, I get an pylance error:

Cannot access member "add" for type "AsyncSession"

It works none the less, but the type hinting etc. is messed up.

To Reproduce

from sqlalchemy.ext.asyncio import AsyncSession

... # init the session, etc. pp

session.add()

Error

Cannot access member "add" for type "AsyncSession"

Versions

• Python: 3.11
• SQLAlchemy: 1.4.32

Additional context

No response

[zzzeek]

hi -

make sure you have no SQLAlchemy stubs installed within pylance they are still on sqlalchemy 1.4, it's a stubs problem.

[zzzeek]

oh this is SQLAlchemy 1.4 ? then this is part of sqlalchemy2-stubs, sorry