# PyPika

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


Source: https://findsoftware.frbit.cloud/pypika/
Last reviewed: 2026-11-16
Listed since: 2026-11-16

## Record

### Links

- home: https://pypika.readthedocs.io/en/latest/
- repository: https://github.com/kayak/pypika
- docs: https://pypika.readthedocs.io/en/latest/

### Identity

- status: active
- maintainer: KAYAK Germany, GmbH
- maintainerType: company
- parent: unknown
- firstRelease: 2016
- hqCountry: unknown

### Kind

- category: library
- hosting: python
- language: python
- runtime: python
- runtimeMin: python 3.9
- basedOn: unknown

### Content

- contentStore: not applicable
- databases: mysql, sqlserver, postgres, oracle
- adminUi: not applicable
- headlessApi: not applicable
- templating: not applicable
- i18n: not applicable

### Rendering and deploy

- runsAs: not applicable
- renderingModes: not applicable
- installMethod: pip

### License

- licenseModel: open-source
- license: Apache-2.0

### Releases

- currentMajor: 0
- latestReleaseDate: 2026-02-04

### Adoption

- githubStargazers: 2925
- packagistDownloads: not applicable
- npmWeeklyDownloads: not applicable
- contributors: 115
- pluginCount: unknown
- packagistMonthlyDownloads: unknown
- ecosystemsMonthlyDownloads: unknown
- httpArchiveSites: unknown
- wordpressActiveInstalls: unknown
- dependentRepos: unknown
- dependentPackages: unknown

### Sources

- urls: https://pypika.readthedocs.io/en/latest/ (read 2026-11-16)
- urls: https://api.github.com/repos/kayak/pypika (read 2026-11-16)
- urls: https://pypika.readthedocs.io/en/latest/ (read 2026-11-16)
- maintainer: https://github.com/kayak/pypika/blob/master/README.rst (read 2026-11-16)
- maintainerType: https://github.com/kayak/pypika/blob/master/README.rst (read 2026-11-16)
- firstRelease: https://pypi.org/pypi/pypika/json (read 2026-11-16)
- category: https://github.com/kayak/pypika/blob/master/README.rst (read 2026-11-16)
- language: https://api.github.com/repos/kayak/pypika (read 2026-11-16)
- runtime: https://github.com/kayak/pypika/blob/master/README.rst (read 2026-11-16)
- runtimeMin: https://github.com/kayak/pypika/blob/master/README.rst (read 2026-11-16)
- installMethod: https://github.com/kayak/pypika/blob/master/README.rst (read 2026-11-16)
- license: https://github.com/kayak/pypika/blob/master/README.rst (read 2026-11-16)
- databases: https://github.com/kayak/pypika/blob/master/README.rst (read 2026-11-16)
- currentMajor: https://api.github.com/repos/kayak/pypika/releases (read 2026-11-16)
- latestReleaseDate: https://api.github.com/repos/kayak/pypika/releases (read 2026-11-16)
- githubStargazers: https://api.github.com/repos/kayak/pypika (read 2026-11-16)
- contributors: https://api.github.com/repos/kayak/pypika/contributors (read 2026-11-16)

## Notes

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.

---

Data licensed CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Attributes are recorded, never scored; absent means unknown.
Credit, in full: FindSoftware, CC BY 4.0
