"method" of "AppenderQuery" does not return a value

[CrafterSvK]

Describe the bug When using static typing on relationship which is lazy='dynamic' I used "AppenderQuery", which is the one which SQLAlchemy gave me at runtime. I type ignored it as Mapped does not support it clearly. After I use where/order_by mypy says: error: "where" of "AppenderQuery" does not return a value. Which is clearly not true, typing says it returns None, but at runtime it returns something.

Expected behavior Typing should reflect reality.

To Reproduce

class Page(Base):
    user_pages: AppenderQuery = relationship('UserPage', back_populates='page', lazy='dynamic')  # type: ignore

Error

error: "where" of "AppenderQuery" does not return a value

Versions.

• OS: Linux x86-64
• Python: 3.10.6
• SQLAlchemy: 1.4.40
• mypy: 0.871
• SQLAlchemy2-stubs: provided by SQLAlchemy[mypy]

Additional context Still trying to figure out real ways how to type, already existing code.

Thanks and have a nice day!