pypika

library0.51.1pypypi✓ verified 27d ago

PyPika is a SQL query builder API for Python, allowing users to construct SQL queries programmatically. It supports various SQL dialects like PostgreSQL, MySQL, Oracle, and Redshift, and even JQL. The library is actively maintained, with frequent patch and minor releases, currently at version 0.51.1.

database

pip install pypika

github ↗package ↗

INSTALL

IMPORT

SIG · PYPIKA

pypika

databasepythonv0.51.1

Install

1.6s avg

Import

67ms

Disk

17MB

Pass rate

10/ 10

Env Coverage10 / 10

glibc

3.9–3.13

musl

3.9–3.13

Install & Compatibility

Where this runs

tested against v0.51.1 · pip install

no network on importno background threads

Install × environment matrix

Each cell = how many times install + import succeeded across repeated harness runs. Partial = flaky.
glibc = Debian/Ubuntu slim · musl = Alpine Linux

musl

py 3.10–3.95 runs

installs and imports cleanly · install 0.0s · import 0.070s · 18.7MB

glibc

py 3.10–3.95 runs

installs and imports cleanly · install 1.6s · import 0.064s · 19MB

17MB installed

● package 17MB

Code

Verified usage

Verified import paths — ran on the pinned version, not inferred.

Query

✓ from pypika import Query

Table

✓ from pypika import Table

Field

✓ from pypika import Field

functions

✓ from pypika import functions as fn

Commonly imported with an alias for brevity.

PostgreSQLQuery

✓ from pypika.postgres import PostgreSQLQuery

✗ from pypika import PostgreSQLQuery

Dialect-specific query classes are in submodules.

This quickstart demonstrates how to construct basic SELECT queries, including filtering with WHERE, using aggregate functions, and performing JOINs and GROUP BY clauses using PyPika's fluent API.

from pypika import Query, Table, Field from pypika import functions as fn customers = Table('customers') orders = Table('orders') # Basic SELECT statement q1 = Query.from_(customers).select(customers.id, customers.name, customers.email) print(f"\nBasic Select:\n{q1.get_sql()}") # Select with WHERE clause and function q2 = Query.from_(orders).select(orders.id, orders.amount).where(orders.amount > 100) print(f"\nSelect with WHERE:\n{q2.get_sql()}") # Select with JOIN and GROUP BY q3 = Query.from_(customers).join(orders).on(customers.id == orders.customer_id) \ .groupby(customers.name).select(customers.name, fn.Sum(orders.amount)) print(f"\nSelect with JOIN and GROUP BY:\n{q3.get_sql()}")

Debug

Known issues

gotchaAlways call `.get_sql()` on your query object to render the SQL string. Without it, you'll be working with the PyPika query object itself, not the executable SQL.

fix

Append `.get_sql()` to your query chain, e.g., `query_object.get_sql()`.

affects: All versions

gotchaBe mindful of SQL dialect differences, especially with quoting characters and specific functions. PyPika defaults to standard SQL but allows specifying a dialect.

fix

Instantiate a dialect-specific query class (e.g., `PostgreSQLQuery`, `MySQLQuery`) or pass `dialect=Dialects.POSTGRES` (or similar) to `get_sql()`. For quoting issues, `get_sql(quote_char=None)` can be useful for databases like SQLite or when embedding in environments that handle quoting.

affects: All versions

gotchaDo not confuse string literals with `Field` objects. When referring to column names, use `Table.field_name` or `Field('field_name')`. Only use raw strings for actual string values in WHERE clauses, etc., to prevent SQL injection.

fix

Use `table.column_name` for column references. For string values in comparisons, ensure they are passed as regular Python strings, PyPika handles their escaping/quoting.

affects: All versions

Upgrade

Version history

0.51.1latest on PyPI · released Feb 4, 2026

Audit

Dependencies

PythonrequiredPyPika requires Python 3.8 or newer.

Agent activity

13 hits · last 30 days

node

Resources

githubhttps://github.com/kayak/pypika ↗

packagehttps://pypi.org/project/pypika/ ↗