PyRank
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.
PyPI GitHub Verified repo
No known security advisories. The current version has no OSV.dev malware reports and no critical or high-severity vulnerabilities.

pypika has 13.3M monthly downloads and 3K GitHub stars. Version 0.51.1, first published in 2016.

It is stably maintained under a permissive license, last released in Feb 2026.

It is built on top of typing-extensions. It is used by 91 tracked packages, including chromadb, tecton and mstrio-py.

GitHub topics include sql, functional and builder.

Shared Repository
This package shares its GitHub repository (kayak/pypika) with 1 other package. Stars, forks, and other GitHub metrics reflect the entire repository.
Downloads
Day
404.8K
Week
3.0M
Month
13.3M
Stars
2.9K
Forks
329
Issues
192
Version
0.51.1

Package Insights

What's this?
Score breakdown - each component scores 0-100, weighted by percentage
Maintenance
65
Popularity
73
Adoption
70
Community
80
Provenance
100
How the maintenance status was determined
Last commit
152 days ago
Monthly downloads
13,285,733
Active
Activity within 30 days
• Stable
Activity within 31-180 days
Minimal
Activity within 181-365 days, or no activity data
At Risk
No activity for > 365 days, but > 10,000 monthly downloads
Archived
Repository flagged as archived on GitHub
How the popularity category was determined
Monthly downloads
13,285,733
Stars
2,920
Stars per 1k downloads
0.22
• Industry Standard
> 10,000,000 monthly downloads
Hidden Gem
< 0.5 stars per 1k downloads and > 100,000 monthly downloads
Community Favorite
> 5 stars per 1k downloads
Rising Star
Balanced ratio of stars to downloads
Unknown
Fewer than 1,000 monthly downloads, or no star data
How download momentum is calculated
Week daily avg
421,436
Month daily avg
442,858
Momentum
-4.8%
((week_daily_avg - month_daily_avg) / month_daily_avg) * 100
Python version support tiers
requires_python
Not specified
Cutting Edge
Minimum supported version is 3.12 or newer
Modern
Minimum supported version is 3.9, 3.10, or 3.11
Legacy
Supports 3.8 or older (or Python 2)
• Unknown
No requires_python specified or unparseable
Package does not declare a minimum Python version.
License categories
License
Apache License Version 2.0
• Permissive
MIT, Apache, BSD, ISC, Unlicense, CC0, etc.
Copyleft
GPL, LGPL, AGPL, MPL, EPL, etc.
Proprietary
Commercial, all rights reserved, custom EULAs
Unknown
No license specified, or none of the above match
How the release cadence was determined
Last release
152 days ago
Total releases
216
Releases/year
21.6
• Rapid
Last release within 365 days and > 12 releases/year
Regular
Last release within 365 days
Slow
Last release 366-730 days ago
Stalled
Last release > 730 days ago, or no releases
Unknown
No usable release date available
How contributor risk was determined
Contributors
103
Monthly downloads
13,285,733
High Load
≤ 2 contributors and ≥ 50,000 monthly downloads
Moderate Load
< 10 contributors and ≥ 500,000 monthly downloads
Low Load
< 25 contributors and ≥ 5,000,000 monthly downloads, or sole maintainer with ≥ 10,000 monthly downloads
• Balanced
Enough contributors for the package's popularity
Unknown
No contributor data available
Engagement
66
 
Issue Burden
65.8
per 1k stars
Discussions
0.0
per 1k stars
Fork Ratio
31.3%
contrib / forks
Stale Release
No
 
PR Velocity
Quiet
 

Weekly Downloads

GitHub Stars

Not all downloads include detailed metadata. Breakdowns reflect the subset that does.

Downloads by OS

Linux 285.6K
Windows 20.5K
macOS 10.7K

Python Versions

3.12
40.8% 114.0K
3.11
22.4% 62.7K
3.7
15.1% 42.3K
3.14
10.9% 30.5K
3.13
10.8% 30.1K

Top Countries

1. US US
236.9K
2. IN IN
16.9K
3. IE IE
12.5K
4. DE DE
8.5K
5. SG SG
3.7K
6. NL NL
3.6K
7. CN CN
3.6K
8. KR KR
2.6K
9. JP JP
2.5K
10. BR BR
2.3K
GitHub Topics
Tags from the package's GitHub repository describing what it does.

Package Information

License
Apache License Version 2.0
First Release
July 8, 2016
Last Release
5 months ago
Last Commit
5 months ago
Latest Version
0.51.1
Total Releases
216
Contributors
103
Open PRs
40
Archived
No
Author
Timothy Heys
Python Versions
3
Wheels
py2 py3
Keywords
pypika python query builder querybuilder sql mysql postgres psql oracle vertica aggregated relational database rdbms business analytics bi data science analysis pandas orm object mapper
Tracking Since
January 6, 2026
Data Updated
July 5, 2026
Data Freshness
Fresh

Links