Skip to main content

SQLQuack
by SQLStack

Run warehouse SQL locally.

Translate warehouse SQL into DuckDB SQL for local testing and CI - without a running warehouse.
Website · Docs · Playground · Quickstart

SQLQuack checks SQL and converts queries to DuckDB SQL

Why SQLQuack?

SQL that runs on two engines doesn't always return the same answer. NULLs, decimal arithmetic and casts can behave differently.

SQLQuack checks its conversion rules against real results from the source warehouse. It handles those differences deliberately and gives you precise diagnostics when it can't convert a query - not plausible-looking SQL and crossed fingers.

SQLQuack's parser started as a fork of Polyglot, a Rust SQL transpiler inspired by SQLGlot. The translation to DuckDB, the typing and the recorded evidence behind them are SQLQuack's own.

  • Check early. Catch invalid SQL before it reaches the warehouse.
  • Test locally. Convert queries to DuckDB SQL for tests against small fixtures.
  • See what's blocking you. Scan a SQL project to find what converts and what needs attention.
  • Choose what to accept. Allow or refuse each known difference in sqlquack.toml.

Get started

pip install sqlquack

# Convert your first query
echo "SELECT 1 AS total" | sqlquack convert --no-config

# Check a SQL file
sqlquack check query.sql

# Convert a query using the tables in sources/*.yml
sqlquack convert query.sql

Or try the playground - no installation needed.

See the supported dialects and coverage, project guide and defaults for known differences for the details.

Use it from Python

import sqlquack

result = sqlquack.convert(
    sql="SELECT 1 AS total",
    options=sqlquack.ConvertOptions(no_config=True),
)

Python API

Running the suites

SQLQuack's parsers and conversion rules are checked against evidence recorded on the real engines. Rerunning it needs no account:

git clone https://github.com/sqlstack-io/sqlquack && cd sqlquack
uv sync
make check-syntax DIALECT=snowflake    # rerun the parser against recorded syntax evidence
make check-convert DIALECT=snowflake   # replay recorded translations on DuckDB
Command What it does
make pending DIALECT=snowflake What isn't recorded yet, in both suites
make check-syntax DIALECT=snowflake Rerun the parser against recorded evidence (offline)
make record-syntax DIALECT=duckdb Record evidence for new syntax cases
make check-convert DIALECT=snowflake [CASES=temporal] Replay recorded translations on DuckDB (offline)
make record-convert DIALECT=snowflake Record new translation cases on Snowflake
make verify-changed Replay only the cases whose conversion or recording changed since its last run
make check-merge The static checks and the Rust tests every change must pass
make test-crate CRATE=sqlquack-evidence One crate's tests
make python-api Build the Python module and run its API tests

A pull request runs what its changed files need. Documentation and website changes build and check the site. Other changes run make check-merge, the Python tests and the replay. The replay reuses main's judgement for every case whose conversion and recording are unchanged, and replays only the rest. A change under one of the full-replay paths in scripts/replay_scope/constants.py replays every case: the DuckDB pin, the lock files, the replay, comparison and policy crates, the error kinds, CI's toolchain and the evidence pin. A change outside every crate the sqlquack binary is built from replays nothing.

Recording needs the dialect's engine: DuckDB and SQLite record locally, while Snowflake, BigQuery and Databricks need a connection. Recording Snowflake syntax evidence isn't public yet. make help lists every target.

Credits

SQLQuack wouldn't exist without two projects:

  • Polyglot by Tobias (@tobilg). SQLQuack's tokenizer, parser and syntax tree are a modified fork of Polyglot's, and much of that code is still his. Tobias also fixed many issues I reported while building SQLBuild on Polyglot.
  • SQLGlot by Toby Mao and contributors, for years of work on SQL transpilation that this space builds on.

Both are MIT licensed. Their licence texts are in THIRD_PARTY_NOTICES and ship with every release.

SQLQuack goes a different way from both on translation. It doesn't rewrite the tree and print it out. It checks each rule against recorded warehouse results and refuses what it can't prove.


Built in Rust. Free and open source. Apache 2.0.

Questions and feedback are welcome on Discord.

Part of SQLStack.

Metadata

Release files for sqlquack-cli 0.22.0

For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.

Source distribution (sdist)

Source distribution for sqlquack-cli 0.22.0
File Size Uploaded Provenance Actions
sqlquack_cli-0.22.0.tar.gz 2.8 MB With provenance Details for sqlquack_cli-0.22.0.tar.gz

Built distributions (wheels)

Table of built distributions (wheels) for sqlquack-cli 0.22.0
File Actions
sqlquack_cli-0.22.0-py3-none-win_amd64.whl Python 3 none Windows x86-64 Details for sqlquack_cli-0.22.0-py3-none-win_amd64.whl
sqlquack_cli-0.22.0-py3-none-manylinux_2_28_x86_64.whl Python 3 none Linux glibc 2.28+ x86-64 Details for sqlquack_cli-0.22.0-py3-none-manylinux_2_28_x86_64.whl
sqlquack_cli-0.22.0-py3-none-manylinux_2_28_aarch64.whl Python 3 none Linux glibc 2.28+ ARM64 Details for sqlquack_cli-0.22.0-py3-none-manylinux_2_28_aarch64.whl
sqlquack_cli-0.22.0-py3-none-macosx_11_0_arm64.whl Python 3 none macOS 11.0+ ARM64 Details for sqlquack_cli-0.22.0-py3-none-macosx_11_0_arm64.whl
sqlquack_cli-0.22.0-py3-none-macosx_10_15_x86_64.whl Python 3 none macOS 10.15+ x86-64 Details for sqlquack_cli-0.22.0-py3-none-macosx_10_15_x86_64.whl

Total release size: 164.7 MB

Release files / sqlquack_cli-0.22.0.tar.gz

Download URL sqlquack_cli-0.22.0.tar.gz
Size 2.8 MB
Tags Source
SHA-256 checksum
How to use checksums
67ba18b1cab413d7a0d3276a5e0113bac761db6adfc6a55eab0377f120fe6adc
BLAKE2b-256 checksum
How to use checksums
877c6a9401301ebc212c2226750a5a16de32979e94bc55368299a4586182b43d
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

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 Nov 19, 2026.

Transparency log

Release files / sqlquack_cli-0.22.0-py3-none-win_amd64.whl

Download URL sqlquack_cli-0.22.0-py3-none-win_amd64.whl
Size 30.5 MB
Tags Python 3 Windows x86-64
SHA-256 checksum
How to use checksums
871164c2606b7c53a2dbdf359a6c18b1fb6878a1b0445bc7ed0c9b5e6ecbc76f
BLAKE2b-256 checksum
How to use checksums
66764770cafd4b8f85badc9ccb5d6cd6b7483c1af50c63c0d7b7e136fd0f7fb0
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

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 Nov 19, 2026.

Transparency log

Release files / sqlquack_cli-0.22.0-py3-none-manylinux_2_28_x86_64.whl

Download URL sqlquack_cli-0.22.0-py3-none-manylinux_2_28_x86_64.whl
Size 36.7 MB
Tags Linux glibc 2.28+ x86-64 Python 3
SHA-256 checksum
How to use checksums
f79322233cf9d835e683da4eeb812bcc07b027a9e8dc4eb7b12f311b74ae47c0
BLAKE2b-256 checksum
How to use checksums
7f7e9f22442c63c8f790ac6f8f12a9a4cffa68a6569f0030e07d88965420b2af
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

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 Nov 19, 2026.

Transparency log

Release files / sqlquack_cli-0.22.0-py3-none-manylinux_2_28_aarch64.whl

Download URL sqlquack_cli-0.22.0-py3-none-manylinux_2_28_aarch64.whl
Size 32.3 MB
Tags Linux glibc 2.28+ ARM64 Python 3
SHA-256 checksum
How to use checksums
e556c052faf1db7591a5baa2fb24e234fd0caca1c47cf021936a5b8c7ea34e96
BLAKE2b-256 checksum
How to use checksums
b37beca3f951fa2fc85400d8bd01776f3e2da26e09597d286f7895e06bd27203
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

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 Nov 19, 2026.

Transparency log

Release files / sqlquack_cli-0.22.0-py3-none-macosx_11_0_arm64.whl

Download URL sqlquack_cli-0.22.0-py3-none-macosx_11_0_arm64.whl
Size 29.8 MB
Tags Python 3 macOS 11.0+ ARM64
SHA-256 checksum
How to use checksums
90555e7758c8b12c9065f33f02525af221c6a2f4b2f1b3e3d90f4582feb2d300
BLAKE2b-256 checksum
How to use checksums
ac8f08dbb66b5ff8693329077ca9ea16998046688aec72869a3d6d4158b0e571
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

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 Nov 19, 2026.

Transparency log

Release files / sqlquack_cli-0.22.0-py3-none-macosx_10_15_x86_64.whl

Download URL sqlquack_cli-0.22.0-py3-none-macosx_10_15_x86_64.whl
Size 32.5 MB
Tags Python 3 macOS 10.15+ x86-64
SHA-256 checksum
How to use checksums
d930f61dc2fd03d0841f747916e996795f8900453842124258e8211f175fdb69
BLAKE2b-256 checksum
How to use checksums
fe955a9d17eb30d433122201500be8ccc09b9bc75d6707b5e870d2e3da1bb9e3
Upload date
Uploaded using Trusted Publishing?
What is trusted publishing?
Yes
Uploaded via twine/7.0.0 CPython/3.13.16

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 Nov 19, 2026.

Transparency log

Security for sqlquack-cli 0.22.0

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.

Full provenance

All 6 files in this release have been uploaded with provenance metadata.

Select from 6 files

Attestation for sqlquack_cli-0.22.0.tar.gz

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 Nov 19, 2026.

Transparency log

A note on package security

PyPI is a repository for distributing packages, not a service for auditing them. While third-party security researchers and our staff do their best to detect and remove malicious packages, PyPI cannot guarantee the quality, security or suitability of any given package.

To learn more about protecting yourself from malicious actors, visit our package security documentation.

Release history Release notifications | RSS feed

This release

0.22.0 This release

6 release files Full provenance

Anthropic, PBC Visionary sponsor Bloomberg Visionary sponsor Hudson River Trading Visionary sponsor Meta Visionary sponsor NVIDIA Visionary sponsor Microsoft Sustainability sponsor Depot Continuous Integration AWS Cloud computing and Security Sponsor Datadog Monitoring Fastly CDN Google Download Analytics Sentry Error logging StatusPage Status page