vertica_python not working with SQLAlchemy

[anilmcmt]

When I try to connect with latest version of sqlalchemy 2.0, we have faced the issue, Older version it's fine.

import sqlalchemy as sa
engine = sa.create_engine('vertica+vertica_python://:data@****:5433/')

conn = engine.connect()

sqlalchemy.exc.ObjectNotExecutableError: Not an executable object: 'select version()'

SQLAlchemy Version in Use
2.0.2

DBAPI (i.e. the database driver)
python_vertica

Database Vendor and Major Version
Vertica 10.1.0

Python Version
3.11

Operating system
Window/Linux
To Reproduce
import sqlalchemy as sa

create engine

engine = sa.create_engine('vertica+vertica_python://:data@****:5433/')
conn = engine.connect()

[sitingren]

Are you using vertica's official sqlalchemy dialect?

[narphu]

The dialect currently only supports SQLAlchemy 1.x versions.

[kriko]

We have implementeted SQLAlchemy 2 support with also support for TLS connections. https://github.com/porkoaiv/vertica-sqlalchemy-dialect