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 on it.

Install

buildpg on PyPI

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.

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

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)

Package facts

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

Tags

More Python Modules packages

See also asyncpg · pgsanity · queries · django-query-builder · jinjasql2 · sqlparams · jinjasql · opentelemetry-instrumentation-asyncpg · asyncpg-trek · datafusion-query-builder