kayak/pypika
PyPika is a python SQL query builder that exposes the full richness of the SQL language using a syntax that reflects the resulting query. PyPika excels at all sorts of SQL queries but is especially useful for data analysis. observed · 2026-08-28
Health v2 · maintenance only
73/100
- Activity 65
- Release rhythm 69
- Longevity 100
How is this computed?
round(0.45*activity + 0.35*rhythm + 0.20*longevity); archived -> min(score, 10) — computed 2026-09-02. Adoption (stars, forks) is never an input.
- gap_med: 10.0
- age_days: 3710
- days_rel: 210
- days_push: 210
- n_releases_24m: 3
Adoption not part of the score
2927 stars · 333 forks observed · 2026-08-28
What it is AI-extracted, prompt v1, taxonomy v1, 2026-08-30, confidence not recorded
PyPika is a Python SQL query builder library that exposes the full richness of SQL through a builder-pattern API mirroring the resulting query syntax. It is designed for data analysis, avoiding string concatenation while remaining extensible to vendor-specific SQL dialects.
Use cases
- build sql queries in python without string concatenation
- programmatically generate select insert update and delete statements
- write analytics queries against relational databases
- generate vendor-specific sql for mysql postgres oracle vertica
- replace handwritten sql in data pipelines
- compose complex queries with joins and aggregations in python
When to choose
- you need programmatic sql generation with full sql expressiveness
- you want a lightweight alternative to a full orm
- you are building data analysis or BI tooling in python
- you need to target multiple sql database dialects
When to avoid
- you want automatic schema validation or type-safe queries
- you need a full orm with models, migrations, and relationship management
- you prefer writing raw sql directly
Facets
library · maturity stable
database orm serialization databases data-science analytics developer-tools python sql-query-builder query-builder sql-generation data-analysis pandas
2 sources
- readme: https://github.com/kayak/pypika · fetched 2026-08-28 · 6e86e6184356
- registry_pypi: https://pypi.org/pypi/pypika/json · fetched 2026-08-29 · f6c962e92ac7
Member repositories
| Repository | Role | Health v2 |
|---|---|---|
| kayak/pypika | main | 73 |
For agents
Data as of 2026-08-30T08:39:29.467469+00:00 · Report a problem