sqlalchemy-vertica

What it is and what it does

sqlalchemy-vertica is a SQLAlchemy dialect that translates SQLAlchemy's ORM and SQL expression language into Vertica-compatible SQL. It allows Python developers to interact with Vertica databases using SQLAlchemy's standard APIs rather than raw SQL or Vertica-specific drivers. The package depends on six and sqlalchemy as runtime dependencies and supports multiple connection backends (pyodbc, turbodbc, or vertica-python), which must be installed separately.

The package is a community fork of an earlier sqlalchemy-vertica that was removed from PyPI. According to its own documentation, it is not state-of-the-art and does not follow current SQLAlchemy dialect standards. Development has stalled since early 2020, with no releases or commits for over two years, making it a legacy tool that may not work reliably with modern SQLAlchemy or Vertica versions.

Use it for:

• Migrate a legacy Python application from another database to Vertica while keeping SQLAlchemy ORM code largely unchanged.
• Query Vertica views and tables from a Python application using SQLAlchemy's declarative ORM syntax.
• Build a data pipeline that reads from Vertica using SQLAlchemy's SQL expression language in an older codebase.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

Provides a SQLAlchemy dialect for Vertica, enabling SQLAlchemy applications to connect to and query Vertica databases using standard SQLAlchemy ORM and SQL expression APIs.

No, unless you are maintaining a legacy application already bound to this package. The dialect is abandoned (no commits since 2021), likely incompatible with modern SQLAlchemy versions, and the maintainer explicitly states it does not follow current SQLAlchemy standards. For new projects, seek an actively maintained Vertica dialect or use Vertica's native Python driver directly.

Install

sqlalchemy-vertica on PyPI

pip install sqlalchemy-vertica

uv add sqlalchemy-vertica

poetry add sqlalchemy-vertica

Installing sqlalchemy-vertica

Before you install

Low install friction with only two runtime dependencies (six and sqlalchemy). However, the package is abandoned—last commit was 2021-03-25 and no releases since 2020-01-28. Maintenance has stalled for over two years, raising concerns about compatibility with recent SQLAlchemy versions and Vertica API changes.

License in practice

MIT license is permissive and poses no restrictions on use, modification, or distribution in commercial or private projects.

Quickstart

pip install sqlalchemy-vertica
import sqlalchemy as sa
engine = sa.create_engine('vertica+vertica_python://user:pwd@host:port/database')

Requires one of pyodbc, turbodbc, or vertica-python to be installed separately as the connection driver; the package itself does not bundle these.

Verify before relying

• Whether this dialect works with current SQLAlchemy versions (3.0+) or only legacy versions.
• Whether Vertica API changes since 2021 have broken compatibility with this dialect.
• Current test coverage and whether the codebase passes Vertica's own test suite.

Package facts

Evidence: sqlalchemy_vertica-0.0.5-py3-none-any.whl

Tags

More Front-Ends packages