Data

Tools

Indexes

Applications

Experiments

Summary

An open API service for producing an overview of a list of open source projects.

https://github.com/kayak/pypika

builder data functional python python3 pythonic query sql

Score: 29.138509350024062

Last synced: about 5 hours ago
JSON representation

Repository metadata:

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.

Owner metadata:

GitHub Events

Total
Last Year

Committers metadata

Last synced: 1 day ago

Total Commits: 788
Total Committers: 117
Avg Commits per committer: 6.735
Development Distribution Score (DDS): 0.584

Commits in past year: 21
Committers in past year: 14
Avg Commits per committer in past year: 1.5
Development Distribution Score (DDS) in past year: 0.81

Name Email Commits
Timothy Heys t****s@k****m 328
Michael England m****d@k****m 115
Glenn De Jonghe g****n 26
Robin Papke r****e@k****m 16
Danila Hanchar d****r@w****t 14
Rob Blackbourn r****n@g****m 14
nibrag i****k@g****m 13
andreybondar a****5@g****m 10
Peter Jung p****g@h****z 9
Grigi n****s@g****m 9
Sang-Heon Jeon e****8@g****m 8
aweller a****r@k****m 8
Pearman91 h****s@g****m 7
Jan Hruška j****a@h****z 7
Pavel Sirotkin p****z@g****m 7
inkmix i****x 7
xMsid 3****d 5
Piotr Chwała p****a@s****l 5
Nik Sidnev s****k@g****m 5
Kulu-M l****l@g****m 5
Airton Zanon m****e@a****v 5
Noam Bloom n****m@g****m 5
Nguyen Khac Thanh n****4@g****m 4
Lucas Lira Gomes l****a@k****m 4
Gleb Koveshnikov k****6@g****m 4
Paul Koenig p****g@g****m 4
Waket Zheng w****g@g****m 4
Jervis Whitley j****n 4
Azis a****a@y****m 4
Adam Liddell g****t@a****m 4
and 87 more...

Issue and Pull Request metadata

Last synced: 1 day ago

Total issues: 448
Total pull requests: 438
Average time to close issues: 2 months
Average time to close pull requests: about 2 months
Total issue authors: 313
Total pull request authors: 162
Average comments per issue: 1.72
Average comments per pull request: 2.05
Merged pull request: 334
Bot issues: 0
Bot pull requests: 3

Past year issues: 12
Past year pull requests: 17
Past year average time to close issues: 27 days
Past year average time to close pull requests: 1 day
Past year issue authors: 10
Past year pull request authors: 10
Past year average comments per issue: 1.17
Past year average comments per pull request: 2.06
Past year merged pull request: 12
Past year bot issues: 0
Past year bot pull requests: 1

More stats: https://issues.ecosyste.ms/repositories/lookup?url=https://github.com/kayak/pypika

Top Issue Authors

  • twheys (18)
  • info-rchitect (11)
  • mikeengland (9)
  • aaliddell (5)
  • andreamoro (5)
  • aweller (5)
  • stickystyle (4)
  • Dandi91 (4)
  • zkurtz (4)
  • jet10000 (4)
  • Kulu-M (4)
  • d-ganchar (4)
  • williambdean (4)
  • ghost (3)
  • timbarkerSE (3)

Top Pull Request Authors

  • twheys (94)
  • mikeengland (40)
  • waketzheng (8)
  • nibrag (8)
  • d-ganchar (7)
  • hqsz (7)
  • RobinPapke (7)
  • noambloom (6)
  • AzisK (6)
  • cpinamtz (5)
  • inkmix (5)
  • kongzii (5)
  • YiuRULE (5)
  • nsidnev (4)
  • hfaua (4)

Top Issue Labels

  • enhancement (12)
  • help wanted (9)
  • bug (8)
  • documentation (4)
  • good-first-issue (1)

Top Pull Request Labels

  • dependencies (3)
  • python (1)
  • bug (1)

Package metadata

pypi.org: pypika

A SQL query builder API for Python

  • Homepage: https://github.com/kayak/pypika
  • Documentation: https://pypika.readthedocs.io/
  • Licenses: Apache License Version 2.0
  • Latest release: 0.51.1 (published 7 months ago)
  • Last Synced: 2026-08-25T14:36:20.353Z (1 day ago)
  • Versions: 217
  • Dependent Packages: 33
  • Dependent Repositories: 795
  • Downloads: 12,120,726 Last month
  • Docker Downloads: 493
  • Rankings:
    • Downloads: 0.192%
    • Dependent repos count: 0.423%
    • Dependent packages count: 0.474%
    • Stargazers count: 1.488%
    • Average: 1.513%
    • Forks count: 3.227%
    • Docker downloads count: 3.277%
  • Maintainers (2)
proxy.golang.org: github.com/kayak/pypika

  • Homepage:
  • Documentation: https://pkg.go.dev/github.com/kayak/pypika#section-documentation
  • Licenses: apache-2.0
  • Latest release: v0.51.1 (published 7 months ago)
  • Last Synced: 2026-08-25T14:37:17.024Z (1 day ago)
  • Versions: 81
  • Dependent Packages: 0
  • Dependent Repositories: 0
  • Rankings:
    • Dependent packages count: 5.662%
    • Average: 5.852%
    • Dependent repos count: 6.042%
pypi.org: xpypika

A SQL query builder API for Python

  • Homepage: https://github.com/kayak/pypika
  • Documentation: https://xpypika.readthedocs.io/
  • Licenses: Apache License Version 2.0
  • Latest release: 0.14.9 (published almost 6 years ago)
  • Last Synced: 2026-08-25T14:36:08.460Z (1 day ago)
  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 1
  • Downloads: 9 Last month
  • Rankings:
    • Stargazers count: 1.488%
    • Forks count: 3.227%
    • Dependent packages count: 7.373%
    • Average: 19.808%
    • Dependent repos count: 22.233%
    • Downloads: 64.72%
  • Maintainers (1)
conda-forge.org: pypika

  • Homepage: https://github.com/kayak/pypika
  • Licenses: Apache-2.0
  • Latest release: 0.48.8 (published almost 5 years ago)
  • Last Synced: 2026-03-20T13:07:18.764Z (5 months ago)
  • Versions: 1
  • Dependent Packages: 1
  • Dependent Repositories: 0
  • Downloads: 98,598 Total
  • Rankings:
    • Stargazers count: 8.37%
    • Forks count: 10.641%
    • Average: 20.464%
    • Dependent packages count: 28.82%
    • Dependent repos count: 34.025%
pypi.org: propypika

A SQL query builder API for Python

  • Homepage: https://github.com/kayak/pypika
  • Documentation: https://propypika.readthedocs.io/
  • Licenses: Apache License Version 2.0
  • Latest release: 0.48.10 (published over 1 year ago)
  • Last Synced: 2026-08-25T14:36:09.819Z (1 day ago)
  • Versions: 2
  • Dependent Packages: 0
  • Dependent Repositories: 0
  • Downloads: 14 Last month
  • Rankings:
    • Dependent packages count: 9.817%
    • Average: 32.539%
    • Dependent repos count: 55.262%
  • Maintainers (1)
anaconda.org: pypika

PyPika is a Python API for building SQL queries. The motivation behind PyPika is to provide a simple interface for building SQL queries without limiting the flexibility of handwritten SQL. PyPika is a fast, expressive and flexible way to replace handwritten SQL.

  • Homepage: https://github.com/kayak/pypika
  • Licenses: Apache-2.0
  • Latest release: 0.51.1 (published 4 months ago)
  • Last Synced: 2026-07-30T04:04:10.627Z (28 days ago)
  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
  • Downloads: 0 Total
  • Rankings:
    • Dependent packages count: 35.952%
    • Dependent repos count: 39.201%
    • Average: 48.586%
    • Downloads: 70.604%
nixpkgs-23.11: python310Packages.pypika

A python SQL query builder

nixpkgs-unstable: python314Packages.pypika

Python SQL query builder

nixpkgs-unstable: python313Packages.pypika

Python SQL query builder

nixpkgs-24.05: python311Packages.pypika

A python SQL query builder

guix: python-pypika

SQL query builder API for Python

nixpkgs-24.11: python311Packages.pypika

Python SQL query builder

pkgsrc-netbsd-x86_64-10.1-all: databases/py-pypika

SQL query builder API for Python

  • Homepage: https://github.com/kayak/pypika
  • Documentation: https://pkgsrc.se/databases/py-pypika
  • Licenses: apache-2.0
  • Latest release: 0.51.1 (published 5 months ago)
  • Last Synced: 2026-05-27T05:46:35.674Z (3 months ago)
  • Versions: 1
  • Dependent Packages: 0
  • Dependent Repositories: 0
  • Rankings:
    • Dependent repos count: 0.0%
    • Dependent packages count: 0.0%
    • Average: 100%
nixpkgs-24.11: python312Packages.pypika

Python SQL query builder

nixpkgs-24.05: python312Packages.pypika

A python SQL query builder

nixpkgs-23.11: python311Packages.pypika

A python SQL query builder

Dependencies

requirements-dev.txt pypi
  • Sphinx ==1.6.5 development
  • black ==21.5b1 development
  • bumpversion ==0.5.3 development
  • coverage ==5.1 development
  • parameterized ==0.7.0 development
  • sphinx-rtd-theme ==0.2.4 development
  • tox ==3.14.3 development
  • tox-gh-actions ==0.3.0 development
  • tox-venv ==0.4.0 development
.github/workflows/ci.yml actions
  • actions/checkout v4 composite
  • actions/setup-python v4 composite
  • pre-commit/action v3.0.0 composite
pyproject.toml pypi
setup.py pypi
requirements.txt pypi
  • typing_extensions >=4.5.0
.github/workflows/release.yml actions
  • actions/checkout v5 composite
  • actions/download-artifact v4 composite
  • actions/setup-python v6 composite
  • actions/upload-artifact v4 composite
  • pypa/gh-action-pypi-publish release/v1 composite