FindSoftware

PyPika

Python API that builds SQL queries through a builder interface, with query classes for several database platforms.

PyPika is a Python API that builds SQL queries through a builder pattern. A query is assembled from tables, fields and methods, and it becomes SQL text when cast to a string or passed through get_sql. The README presents it as a way to replace handwritten SQL, designed with data analysis in mind. Its platform-specific query classes handle differences between database vendors, such as quote characters.

Worth knowing

The README says validation of SQL correctness is not a goal, so the caller checks inputs and handles database errors.

Identity

Status
Active
Maintainer
KAYAK Germany, GmbH3
Maintained by
Company3
First release
20164

Rendering and deploy

Install with
pip3

Releases

Current major version
Pre-1.05
Last release
2026-02-045

Adoption

GitHub stars
2,9252
Contributors
1156

Why these figures do not compare

Sources

  1. 2026-11-16: links
    pypika.readthedocs.io/en/latest/
  2. 2026-11-16: links, Written in, GitHub stars
    api.github.com/repos/kayak/pypika
  3. 2026-11-16: Maintainer, Maintained by, Categories, Runtime, Minimum runtime, Install with, License, Databases
    github.com/kayak/pypika/blob/master/README.rst
  4. 2026-11-16: First release
    pypi.org/pypi/pypika/json
  5. 2026-11-16: Current major version, Last release
    api.github.com/repos/kayak/pypika/releases
  6. 2026-11-16: Contributors
    api.github.com/repos/kayak/pypika/contributors

Last reviewed · Listed since Edit on GitHubThis page as markdownas JSON