buildpg

What it is and what it does

buildpg is a query builder that translates Python expressions into PostgreSQL prepared statements with parameter binding. It accepts named placeholders (`:foo`, `:bar`) in SQL strings and replaces them with positional parameters (`$1`, `$2`) suitable for asyncpg, while collecting the parameter values into a list. It also provides a `V()` wrapper for SQL identifiers and constants, allowing you to build complex WHERE clauses using Python operators (`&` for AND, `|` for OR, `==` for equality, etc.) and SQL functions like `funcs.count()`, `funcs.upper()`, and `funcs.position()`.

The package includes an optional asyncpg integration layer that wraps pool and connection methods with `*_b` variants (e.g., `fetch_b`, `fetchval_b`, `execute_b`) that accept buildpg-style named parameters and handle the rendering internally. It has no external runtime dependencies and installs as a pure Python wheel. However, the project is no longer maintained—the last release was in March 2022 and the repository has seen no commits since July 2023.

Use it for:

• Build parameterized SELECT queries with dynamic WHERE clauses by combining V() objects with Python operators instead of string concatenation.
• Insert multiple rows using the Values() helper to generate column names and placeholders from keyword arguments.
• Construct complex conditionals programmatically—add AND/OR conditions only when certain flags are true, avoiding manual SQL string building.
• Wrap asyncpg pool operations to accept named parameters directly without manually calling render() before each query.
• Generate SQL with PostgreSQL-specific operators (contains @>, overlap &&, text search @@) using Python method calls on V() objects.

Worth the install?

AI-flagged interpretation of the facts on this page — verify before relying

buildpg constructs PostgreSQL prepared statements with named parameter substitution and asyncpg integration, supporting complex WHERE clauses, value sets, and SQL operators via Python expressions.

Yes, if you are using asyncpg and want to avoid manual string concatenation for parameterized queries, and you accept the maintenance risk. The package is stable and has no known vulnerabilities, but it is abandoned and will not adapt to breaking changes in asyncpg or Python. Use it for new projects only if you are comfortable pinning asyncpg and Python versions, or if you plan to fork and maintain it yourself.

Install

buildpg on PyPI

pip install buildpg

uv add buildpg

poetry add buildpg

Installing buildpg

Before you install

Low install friction with no runtime dependencies. However, the package is abandoned—last release was 2022-03-01 and no commits since 2023-07-20. It remains functional for Python 3.7–3.9 but will not receive updates for breaking changes in asyncpg or Python itself.

License in practice

MIT license is permissive; you may use, modify, and distribute buildpg freely in proprietary or open-source projects with minimal restrictions.

Quickstart

from buildpg import render, V

sql, params = render('select * from mytable where x=:foo', foo=123)
# Returns: ('select * from mytable where x=$1', [123])

# With asyncpg wrapper:
import asyncio
from buildpg import asyncpg

async def query():
    async with asyncpg.create_pool_b('postgres://localhost/db') as pool:
        result = await pool.fetchval_b('select count(*) from t where id=:id', id=42)

Requires asyncpg to be installed separately if using the asyncpg wrapper methods; PostgreSQL server required for actual query execution.

Verify before relying

• Whether the package remains compatible with recent asyncpg versions (last tested with versions from early 2022).
• Whether Python 3.10+ support is confirmed despite classifiers listing only up to 3.9.

Package facts

Evidence: buildpg-0.4-py3-none-any.whl

Tags

More Python Modules packages