How can I contribute about typing issue and make it support both of version 1.4 and 2+?

[fResult]

Ensure stubs packages are not installed

• No sqlalchemy stub packages is installed (both sqlalchemy-stubs and sqlalchemy2-stubs are not compatible with v2)

Verify if the api is typed

• The api is not in a module listed in #6810 so it should pass type checking

Describe the typing issue

How can we make it support back to the SQLAlchemy version 1.4?

As I forked this repository and found the or_ and and_ functions, they already have a type

But version 1.4 isn't (my company is not ready to upgrade to v.2)

The public_factory function is inferred as Any (here is the SQLAlchemy 1.4 lib code on my local)

If I do something like this...

... it's work

To Reproduce

Already provided above

Error

Versions

• OS: MacOS
• Python: 3.10.*
• SQLAlchemy: 1.4.*
• Type checker: Pylance VSCode extension v.2024.6.1

Additional context

No response

[CaselIT]

Hi,

For 1.4 you have the stub package https://github.com/sqlalchemy/sqlalchemy2-stubs.
But that's best effort support only.

PR will not be accepted to type the 1.4 branch, since 1.4 is in major bug fix only mode currently.

If you care about typing you should upgrade to version 2.0