SuperSQL: SQL for Humans
SuperSQL is a powerful, pythonic SQL query builder that lets you write SQL using native Python objects.
It is NOT an ORM. There are no magic .save() methods, no hidden lazy-loading, and no confusing state management. You write explicit SQL queries (SELECT, INSERT, UPDATE) using a fluent Python API that looks and feels like SQL, but with the power of Python's type system and tooling.
Features
- Pythonic Syntax: Write SQL using chainable Python methods (
.SELECT().FROM().WHERE()). - Type Safe: Define tables using Python classes for autocomplete and validation.
- Vendor Agnostic: Support for PostgreSQL, MySQL, SQLite, Oracle, and SQL Server.
- Async & Sync: Built for modern async Python (asyncio) but supports sync execution.
- No Magic: You control the exact SQL being generated.
- Pytastic Integration: Built-in schema validation using Pytastic.
Installation
# Install with PostgreSQL support
pip install supersql[postgres]
# Or with all drivers
pip install supersql[postgres,mysql,sqlite]
Quick Start
from supersql import Query, Table
# 1. Connect to your database
query = Query("postgres", database="mydb")
# 2. Define your Table (Dynamic, no class needed!)
users = Table("users")
# 3. Write Pythonic SQL
# SELECT name, email FROM users WHERE age > 25
results = await query.SELECT(
users.name, users.email
).FROM(
users
).WHERE(
users.age > 25
).run()
Why SuperSQL?
SuperSQL gives you the power of a Query Builder without the overhead of an ORM.
- Zero Boilerplate: No need to define classes or duplicate your schema in Python.
- Explicit Control: You control the exact SQL execution.
- Dynamic: Works great with ad-hoc queries or evolving schemas.
Release files for supersql 2026.9.1
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | Provenance | |
|---|---|---|---|---|
| supersql-2026.9.1.tar.gz | 37.8 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| supersql-2026.9.1-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 87.4 kB
Release files / supersql-2026.9.1.tar.gz
| Download URL | supersql-2026.9.1.tar.gz |
|---|---|
| Size | 37.8 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
800368d36db17879df2bdd71455125bf23ef04aa163bdc6444cecbea72174a67
|
|
BLAKE2b-256 checksum How to use checksums |
347a54d7fdb0f23cca7088ba7032777cec7be610c9b1bae5ccc62feaad8cb90f
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/2.3.2 CPython/3.12.3 Linux/7.0.0-31-generic
|
Release files / supersql-2026.9.1-py3-none-any.whl
| Download URL | supersql-2026.9.1-py3-none-any.whl |
|---|---|
| Size | 49.6 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
b53dbdaa95fd9999d791d3dd4827714123440d0382c8680c2f92701fd25e20fb
|
|
BLAKE2b-256 checksum How to use checksums |
0e41db51e079b602022e608d9dad43e6737611f5e624af0ed248a8f49370e692
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
poetry/2.3.2 CPython/3.12.3 Linux/7.0.0-31-generic
|
Security for supersql 2026.9.1
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.
No provenance found
None of the files in this release were uploaded with provenance metadata.
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.
