ibmdb2-sqlglot-plugin 0.0.3

IBM DB2 dialect plugin for sqlglot

ibmdb2-sqlglot-plugin

IBM DB2 dialect plugin for sqlglot — bidirectional transpilation between IBM DB2 and any SQL dialect.

Installation

pip install ibmdb2-sqlglot-plugin

Usage

After installing the package, the ibmdb2 dialect is available in sqlglot automatically — no extra imports needed:

import sqlglot

# Any dialect → IBM DB2
result = sqlglot.transpile("SELECT * FROM users WHERE id = 1", read="mysql", write="ibmdb2")[0]
# → SELECT * FROM `users` WHERE id = 1

# IBM DB2 → any dialect
result = sqlglot.transpile("$t = (SELECT id FROM users); SELECT * FROM $t AS t", read="ibmdb2", write="postgres")[0]
# → WITH t AS (SELECT id FROM users) SELECT * FROM t AS t

What the plugin does

@TODO

Development

## pip install uv # if uv does not exist locally
uv sync            # install dependencies
uv run pytest      # run all tests

License

APACHE LICENSE 2.0