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.
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Filter files by name, interpreter, ABI, and platform.
If you're not sure about the file name format, learn more about wheel file names.
Copy a direct link to the current filters
File details
Details for the file supersql-2026.8.1.tar.gz.
File metadata
- Download URL: supersql-2026.8.1.tar.gz
- Upload date:
- Size: 37.7 kB
- Tags: Source
- Uploaded using Trusted Publishing? No
- Uploaded via:
poetry/2.3.2 CPython/3.12.3 Linux/7.0.0-28-generic
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
4c66130f8f62f6cd4949acca2d59ce2c63f41272c7b9cd738ecab8b5b07a1c53
|
|
| MD5 |
e4643f4923b3dd2b6571dc8bb4255d5d
|
|
| BLAKE2b-256 |
72619114e261c24080872306671de71c5e4468ae1095dc22b68c6dbee0e3f18f
|
File details
Details for the file supersql-2026.8.1-py3-none-any.whl.
File metadata
- Download URL: supersql-2026.8.1-py3-none-any.whl
- Upload date:
- Size: 49.5 kB
- Tags: Python 3
- Uploaded using Trusted Publishing? No
- Uploaded via:
poetry/2.3.2 CPython/3.12.3 Linux/7.0.0-28-generic
File hashes
| Algorithm | Hash digest | |
|---|---|---|
| SHA256 |
774b1a7fe226fff89eb23a4af577f25a0572367b0c08c760cd481d87164f5e3e
|
|
| MD5 |
43a112b3cb7271b89be5061342ed17e1
|
|
| BLAKE2b-256 |
35ebbbdda36d3c1de5f511c0dc28a7feebd4eb4d303908d211e9ade82487f699
|
