"order_by" of "Query" does not return a value (same for limit)

[charlax]

Describe the bug

total = query.order_by(None).count()
items = query.limit(10).offset(10).all()

mypy --strict test.py
error: "order_by" of "Query" does not return a value
error: "limit" of "Query" does not return a value

Expected behavior

This is a valid usage of Query. The doc states that ORM Query is considered legacy in v2, it is still usable.

To Reproduce

from typing import Any

from sqlalchemy.orm import Query


def paginate(query: Query) -> Any:
    total = query.order_by(None).count()
    items = query.limit(10).offset(10).all()
    return [total, items]

Error

mypy --strict test.py
test.py:7: error: "order_by" of "Query" does not return a value
test.py:8: error: "limit" of "Query" does not return a value
Found 2 errors in 1 file (checked 1 source file)

Versions.

❯ pip list
Package           Version
----------------- -------
greenlet          1.0.0
mypy              0.812
mypy-extensions   0.4.3
pip               21.0.1
setuptools        54.2.0
SQLAlchemy        1.4.11
sqlalchemy2-stubs 0.0.1a4
typed-ast         1.4.3
typing-extensions 3.7.4.3

Have a nice day and thanks for the amazing work!

[MaicoTimmerman]

The stubs are being updated frequently and I believe this has been fixed in #70. Can you try install the master branch of the stubs?

[charlax]

Indeed, works fine with master, thanks!

[CaselIT]

We will try to release an update shortly