SqlAlchemy update to 2.0.39 breaks read_sql

[loicdiridollou]

Describe the bug
A clear and concise description of what the bug is.

Poe => mypy

===========================================
Beginning: 'Run mypy on 'tests' (using the local stubs) and on the local stubs'
===========================================

tests/test_io.py:1419: error: Argument 1 to "read_sql" has incompatible type "Select[Row[tuple[int]]] | FromStatement[Row[tuple[int]]] | UpdateBase"; expected "str | Selectable | TextClause | Select[Any] | FromStatement[Any]"  [arg-type]
Found 1 error in 1 file (checked 226 source files)

Running the test suite will raise an error with the latest update of SqlAlchemy to 2.0.39.
For now I have restricted the version of the package to stop at 2.0.38, the typehint needs to be fixed.

Please complete the following information:

• OS: all
• OS Version [e.g. 22]
• python version 3.10-3.12
• version of type checker latest
• version of installed pandas-stubs latest

Additional context
Add any other context about the problem here.

[shirzady1934]

@loicdiridollou I have made the required changes (Update test to use SQLAlchemy 2.0 compatible select statement) . Please review and let me know if anything else is needed. Thanks!