python-sql

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 on this page — 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

python-sql on PyPI

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

Evidence: python_sql-1.8.1-py3-none-any.whl

Keywords: SQL, database, query

Tags

More Python Modules packages