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.8.2
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.8.2.tar.gz | 37.9 kB | Without provenance | Details |
Built distribution (wheel)
| File | Interpreter | ABI | Platform | Reset |
|---|---|---|---|---|
| supersql-2026.8.2-py3-none-any.whl | Python 3 | none | any | Details |
Total release size: 87.5 kB
Release files / supersql-2026.8.2.tar.gz
| Download URL | supersql-2026.8.2.tar.gz |
|---|---|
| Size | 37.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
ec1f234060a7eccd88681f36a12113557b4e7e7fe92f05a542492d7d9d9a6dd4
|
|
BLAKE2b-256 checksum How to use checksums |
5d2620dc477c028f12e28138f78fb4548602c6908abdacee3b78f0994a53ca55
|
| 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.8.2-py3-none-any.whl
| Download URL | supersql-2026.8.2-py3-none-any.whl |
|---|---|
| Size | 49.7 kB |
| Tags | Python 3 |
|
SHA-256 checksum How to use checksums |
dc9b6ebb9d1ddea0cc84f3f8611d3e56c9a8194756dabac99b22a9e6a4bfa6c8
|
|
BLAKE2b-256 checksum How to use checksums |
80f9ef9519aebd0389c586025624fab9a9a5c6f57906b18940b68573c5d2b934
|
| 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.8.2
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.
