Dialects

    All dialects require that an appropriate DBAPI driver is installed.

    The following table summarizes the support level for each included dialect.

    Support Definitions

    Fully tested in CI

    Fully tested in CI indicates a version that is tested in the sqlalchemy CI system and passes all the tests in the test suite.

    Normal support

    Best effort

    Best effort indicates that we try to support basic features on them, but most likely there will be unsupported features or errors in some use cases. Pull requests with associated issues may be accepted to continue supporting older versions, which are reviewed on a case-by-case basis.

    External Dialects

    Currently maintained external dialect projects for SQLAlchemy include:

    Database

    Dialect

    Actian Avalanche, Vector, Actian X, and Ingres

    Amazon Athena

    pyathena

    Amazon Redshift (via psycopg2)

    Apache Drill

    sqlalchemy-drill

    Apache Druid

    Apache Hive and Presto

    PyHive

    Apache Solr

    CockroachDB

    sqlalchemy-cockroachdb

    CrateDB

    crate-python

    EXASolution

    Elasticsearch (readonly)

    elasticsearch-dbapi

    Firebird

    firebolt-sqlalchemy

    Google BigQuery

    Google Sheets

    gsheets

    IBM DB2 and Informix

    IBM Netezza Performance Server [1]

    Microsoft Access (via pyodbc)

    sqlalchemy-access

    Microsoft SQL Server (via python-tds)

    Microsoft SQL Server (via turbodbc)

    sqlalchemy-turbodbc

    MonetDB

    sqlalchemy-monetdb

    OpenGauss

    SAP ASE (fork of former Sybase dialect)

    sqlalchemy-sybase

    SAP Hana

    sqlalchemy-hana

    SAP Sybase SQL Anywhere

    Snowflake

    snowflake-sqlalchemy

    Teradata Vantage

    Supports version 1.3.x only at the moment.