---
id: python-sql
version: "1.8.1"
license: BSD-3-Clause
license_treatment: permissive
maintenance: active
---

# python-sql — Library to write SQL queries

License: permissive · Maintenance: active · Downloads: 106.0K/mo

## What it is and what it does

python-sql is a query builder that lets you write SQL statements as Python objects instead of raw strings. You define tables, columns, and conditions using Python syntax—like `user.select(user.name)` or `user.where(user.active == True)`—and the library generates parameterized SQL and a tuple of bind parameters. This approach prevents SQL injection by separating query structure from values, and makes complex queries (joins, subselects, aggregations, updates, deletes) easier to construct and read.

The library supports SELECT, INSERT, UPDATE, and DELETE operations, with features like joins, GROUP BY, ORDER BY, aggregates, and subqueries. It also provides a Flavor system to adapt output to different SQL dialects (limit/offset styles, parameter markers like `?` or `:0`). With no external dependencies and pure Python implementation, it integrates easily into any project that needs to build queries dynamically without an ORM.

Use it for:

- Build SELECT queries with WHERE, JOIN, GROUP BY, and ORDER BY clauses programmatically without string concatenation.
- Generate INSERT, UPDATE, and DELETE statements with parameterized values to prevent SQL injection.
- Construct complex subqueries and nested conditions using Python operators and method chaining.
- Adapt query output to different SQL dialects (PostgreSQL, MySQL, Oracle, SQLite) via Flavor configuration.
- Generate parameterized queries for use with database drivers that require separate query strings and parameter tuples.

## Worth the install?

AI-flagged interpretation of the facts above — verify before relying.

Constructs SQL queries programmatically using Python syntax instead of string concatenation, generating parameterized SQL and parameter tuples for safe database execution.

Yes. python-sql is a lightweight, dependency-free query builder suitable for projects that need programmatic SQL construction without a full ORM. It's actively maintained, production-stable, has no known vulnerabilities, and works with Python 3.9+. Install it if you're building dynamic queries and want type-safe, injection-proof SQL generation; skip it if you prefer raw SQL strings or a heavier ORM like SQLAlchemy.

## Install

pip install python-sql
uv add python-sql
poetry add python-sql

## Installing python-sql

Before you install: Low friction: pure Python wheel with no runtime dependencies. Actively maintained with a release 133 days ago and production-stable status.

License in practice: BSD-3-Clause permissive license allows commercial and private use with minimal restrictions; attribution required.

Quickstart:

pip install python-sql

from sql import *
user = Table('user')
select = user.select(user.name)
query_string, params = tuple(select)
# ('SELECT "a"."name" FROM "user" AS "a"', ())

Requires Python 3.9 or later.

Verify before relying:

- Whether the package supports all major SQL dialects or only a subset (Flavor configuration hints dialect support but specifics are unclear).
- Performance characteristics when building very large or deeply nested queries.
- Integration patterns with specific database drivers (psycopg2, mysql-connector, etc.) beyond parameter tuple generation.

## Package facts

- License: BSD-3-Clause (permissive)
- Python support: supports_current
- Install friction: low
- Maintenance: active
- Downloads: 106.0K/month (top 15,000 on PyPI)
- Known vulnerabilities: none known

## Tags

SQL query builder python, programmatic SQL generation, parameterized query construction, python sql abstraction, dynamic query building, SQL DSL for python, safe sql parameter binding, query-builder, sql-generation, injection-safe

[View on SkillFed](https://skillfed.io/packages/python-sql) · [View on PyPI](https://pypi.org/project/python-sql/)