libsyntaqlite for Python
libsyntaqlite is a fast, embeddable parser, formatter, and static analyzer for SQLite SQL. The syntaqlite package provides its Python API.
Docs · Playground · GitHub
pip install syntaqlite
The package requires Python 3.10 or later. Wheels are available for Linux (x86_64, aarch64), macOS (x86_64, arm64), and Windows (x86_64).
API
Everything goes through a Syntaqlite instance. Create one and reuse it across many calls:
import syntaqlite
with syntaqlite.Syntaqlite() as sq:
print(sq.format_sql("select 1"))
Formatting
sql = "select u.id, u.name, p.title from users u join posts p on u.id = p.user_id where u.active = 1 and p.published = true order by p.created_at desc limit 10"
print(sq.format_sql(sql))
SELECT u.id, u.name, p.title
FROM users AS u
JOIN posts AS p ON u.id = p.user_id
WHERE
u.active = 1
AND p.published = true
ORDER BY
p.created_at DESC
LIMIT 10;
Raises syntaqlite.FormatError on invalid input.
Parsing
sq.parse() returns a full AST as typed Python objects, one per statement:
stmts = sq.parse("SELECT 1 + 2 FROM foo")
stmt = stmts[0] # SelectStmt
print(type(stmt).__name__) # SelectStmt
print(stmt.columns[0].expr) # BinaryExpr(...)
print(stmt.from_clause) # TableRef(...)
print(stmt.where_clause) # None
Every node type is a __slots__ class with typed attributes, which supports
IDE completion and isinstance checks:
from syntaqlite.nodes import SelectStmt, BinaryExpr
assert isinstance(stmt, SelectStmt)
assert isinstance(stmt.columns[0].expr, BinaryExpr)
Enum and flag fields are IntEnum/IntFlag from syntaqlite.enums:
from syntaqlite.enums import BinaryOp
expr = stmt.columns[0].expr
print(expr.op) # BinaryOp.PLUS
For performance-sensitive code, use sq.parse_raw() to get plain dicts
instead of typed objects.
Tokenizing
for tok in sq.tokenize("SELECT 1 + 2"):
print(tok["text"], tok["category"])
SELECT keyword
other
1 number
other
+ operator
other
2 number
Each token is a dict with text, offset, length, type, and category fields.
Analysis
Check SQL against a schema without touching a database. Catches unknown tables, columns, functions, CTE column mismatches, and more.
schema = syntaqlite.Schema(
tables=[syntaqlite.Table("users", columns=["id", "name", "email"])],
)
result = sq.analyze("SELECT nme FROM users", schema)
for d in result.diagnostics:
print(f"{d.severity}: {d.message}")
error: unknown column 'nme'
Switch output to get formatted diagnostics with source locations and suggestions:
print(sq.analyze(
"SELECT nme FROM users", schema,
output=syntaqlite.AnalysisOutput.TEXT,
))
error: unknown column 'nme'
--> <input>:1:8
|
1 | SELECT nme FROM users
| ^~~
= help: did you mean 'name'?
Schema also accepts raw DDL:
schema = syntaqlite.Schema(ddl="CREATE TABLE orders (id INTEGER, total REAL);")
result = sq.analyze("SELECT * FROM orders", schema)
Column lineage
For query-bearing statements, the result includes column lineage:
schema = syntaqlite.Schema(
tables=[syntaqlite.Table("users", columns=["id", "name", "email"])],
)
result = sq.analyze("SELECT id, name FROM users", schema)
for col in result.lineage.columns:
print(f"{col.name} <- {col.origin}")
id <- users.id
name <- users.name
CLI
The pip package also bundles the syntaqlite binary:
syntaqlite fmt -e "select 1, 2, 3"
syntaqlite analyze query.sql
syntaqlite parse -e "SELECT * FROM users"
The CLI supports pinning to a specific SQLite version or enabling compile-time flags to match your target environment:
syntaqlite --sqlite-version 3.32.0 analyze query.sql
syntaqlite --sqlite-cflag SQLITE_ENABLE_MATH_FUNCTIONS analyze query.sql
See the CLI reference for all commands and flags.
License
Apache 2.0. SQLite components are public domain under the SQLite blessing.
1 maintainer
Release files for syntaqlite 0.10.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Built distributions (wheels)
| File | Reset | |||
|---|---|---|---|---|
| syntaqlite-0.10.1-py3-none-win_amd64.whl | Python 3 | none | Windows x86-64 | Details |
| syntaqlite-0.10.1-py3-none-pyemscripten_2026_0_wasm32.whl | Python 3 | none | PyEmscripten 2026.0+ WebAssembly | Details |
| syntaqlite-0.10.1-py3-none-manylinux_2_28_x86_64.whl | Python 3 | none | Linux glibc 2.28+ x86-64 | Details |
| syntaqlite-0.10.1-py3-none-manylinux_2_28_aarch64.whl | Python 3 | none | Linux glibc 2.28+ ARM64 | Details |
| syntaqlite-0.10.1-py3-none-macosx_11_0_universal2.whl | Python 3 | none | macOS 11.0+ universal2 (ARM64, x86-64) | Details |
| syntaqlite-0.10.1-py3-none-macosx_10_13_universal2.whl | Python 3 | none | macOS 10.13+ universal2 (ARM64, x86-64) | Details |
Total release size: 15.1 MB
Release files / syntaqlite-0.10.1-py3-none-win_amd64.whl
| Download URL | syntaqlite-0.10.1-py3-none-win_amd64.whl |
|---|---|
| Size | 2.6 MB |
| Tags | Python 3 Windows x86-64 |
|
SHA-256 checksum How to use checksums |
91e93dfc36eead4b8501ecf0e931ab43c38b0a2b31644dc21a8493bedfa868ab
|
|
BLAKE2b-256 checksum How to use checksums |
742608b88d446892f49dcdb57f1af47d74bf2f9babf036c64f229becac880d0e
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 16, 2026.
Transparency logRelease files / syntaqlite-0.10.1-py3-none-pyemscripten_2026_0_wasm32.whl
| Download URL | syntaqlite-0.10.1-py3-none-pyemscripten_2026_0_wasm32.whl |
|---|---|
| Size | 266.3 kB |
| Tags | PyEmscripten 2026.0+ WebAssembly Python 3 |
|
SHA-256 checksum How to use checksums |
a4fb0749c8ece1c42681f54eb8e935ff3839c15aa684b774d59d9175ccc8ad69
|
|
BLAKE2b-256 checksum How to use checksums |
29d633f265f54875a85a218572dc1967c5a59a4ec824ea2c1dfba50b4b3ea355
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 16, 2026.
Transparency logRelease files / syntaqlite-0.10.1-py3-none-manylinux_2_28_x86_64.whl
| Download URL | syntaqlite-0.10.1-py3-none-manylinux_2_28_x86_64.whl |
|---|---|
| Size | 3.2 MB |
| Tags | Linux glibc 2.28+ x86-64 Python 3 |
|
SHA-256 checksum How to use checksums |
2fe7947b39889548a345b4e8d394b9cb528a630b46ed5b3d3e60fcb0b0ddc490
|
|
BLAKE2b-256 checksum How to use checksums |
d22e7987e78c2c9d9734a3b2e17d5b28f8f82e7442a5e4499efeaa881e7cf415
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 16, 2026.
Transparency logRelease files / syntaqlite-0.10.1-py3-none-manylinux_2_28_aarch64.whl
| Download URL | syntaqlite-0.10.1-py3-none-manylinux_2_28_aarch64.whl |
|---|---|
| Size | 3.1 MB |
| Tags | Linux glibc 2.28+ ARM64 Python 3 |
|
SHA-256 checksum How to use checksums |
7d21b4e6c0af6fe01147e03e6159e76ecf795b7a1e6ef3ce63e715d3a58a5e78
|
|
BLAKE2b-256 checksum How to use checksums |
f7ebea171eb18fc1a07449e85321b7617677219319b823deff1b3cec8b3feaab
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 16, 2026.
Transparency logRelease files / syntaqlite-0.10.1-py3-none-macosx_11_0_universal2.whl
| Download URL | syntaqlite-0.10.1-py3-none-macosx_11_0_universal2.whl |
|---|---|
| Size | 2.9 MB |
| Tags | Python 3 macOS 11.0+ universal2 (ARM64, x86-64) |
|
SHA-256 checksum How to use checksums |
50f14ff5d3e3d9d9a092cc771e08eb895d36e3bdc2466c3ea741f4fbac92879d
|
|
BLAKE2b-256 checksum How to use checksums |
bffc77e4e8793c39e5a9d5284b449cade5eefbd7e720ac1e1688e7a3b88e2fb6
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 16, 2026.
Transparency logRelease files / syntaqlite-0.10.1-py3-none-macosx_10_13_universal2.whl
| Download URL | syntaqlite-0.10.1-py3-none-macosx_10_13_universal2.whl |
|---|---|
| Size | 3.0 MB |
| Tags | Python 3 macOS 10.13+ universal2 (ARM64, x86-64) |
|
SHA-256 checksum How to use checksums |
df253ddb5d67378637c0d73d2a6bb0947b577211c974a060f9d06ac8ca9d6a0a
|
|
BLAKE2b-256 checksum How to use checksums |
d9ea737d6c1f13651b42ac41dd94b97f4d946cee6b102489ca0104b284e6419b
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
Yes |
| Uploaded via |
twine/7.0.0 CPython/3.13.14
|
Provenance
Provenance describes where a file came from. On PyPI, provenance is shared via attestations, which provide a verifiable record of the build or publishing details. View details, limitations and caveats.
PyPI Publish Attestation
PyPI verified that this artifact, at this checksum, originated from the publisher listed below.
Signed by GitHub Actions, verified by PyPI on Sep 16, 2026.
Transparency log
