sqlalchemy-cubrid 1.2.2

CUBRID dialect for SQLAlchemy

sqlalchemy-cubrid

CUBRID dialect for SQLAlchemy 2.0+.

Requirements

• Python 3.10+
• SQLAlchemy 2.0 – 2.1
• CUBRID-Python driver

Install

pip install sqlalchemy-cubrid

Quick Start

from sqlalchemy import create_engine, text

engine = create_engine("cubrid://dba:password@localhost:33000/demodb")

with engine.connect() as conn:
    result = conn.execute(text("SELECT 1"))
    print(result.scalar())

Features

• Full SQLAlchemy 2.0 dialect with statement caching
• Complete type system — numeric, string, date/time, bit, LOB, and collection types
• SQL compilation — SELECT, JOIN, CAST, LIMIT/OFFSET, subqueries, CTEs, window functions
• DML extensions — ON DUPLICATE KEY UPDATE, MERGE, FOR UPDATE, TRUNCATE
• DDL support — COMMENT, IF NOT EXISTS / IF EXISTS, AUTO_INCREMENT
• Schema reflection — tables, views, columns, PKs, FKs, indexes, unique constraints, comments
• Alembic migrations via CubridImpl (auto-discovered entry point)
• All 6 CUBRID isolation levels
• PEP 561 typed package

Documentation

Guide	Description
Connection	Connection strings, URL format, driver setup, troubleshooting
Type Mapping	Full type mapping, CUBRID-specific types, collection types
DML Extensions	ON DUPLICATE KEY UPDATE, MERGE, GROUP_CONCAT, TRUNCATE, index hints
Isolation Levels	All 6 CUBRID isolation levels, configuration, comparison
Alembic Migrations	Setup, configuration, limitations, batch workarounds
Feature Support	Full comparison with MySQL, PostgreSQL, and SQLite
Development	Dev setup, testing, Docker, coverage, CI/CD

Compatibility

	Python 3.10	Python 3.11	Python 3.12	Python 3.13
Offline Tests	✅	✅	✅	✅
CUBRID 11.4	✅	—	✅	—
CUBRID 11.2	✅	—	✅	—
CUBRID 11.0	✅	—	✅	—
CUBRID 10.2	✅	—	✅	—

Contributing

See CONTRIBUTING.md for guidelines. See docs/DEVELOPMENT.md for dev setup.

Security

See SECURITY.md.

License

MIT — see LICENSE.