NewYour coding agent can read the release notes before it upgrades.Set up the MCP server →
PyPI
PyPI, #1308 most downloaded on PyPI
A SQL query builder API for Python
Latest stable
0.51.1
Last release 9 months ago
04 Feb 2026
Ships unpredictably
gaps range from 9 days to 3.8 years
Rarely documented
notes for 9 of the last 60 stable releases
Nothing withdrawn
no release was ever pulled
10 years old
217 releases · first in 2016
Drag across the ruler to compare, or tap a release to open it.
typefix: Add explicit type annotations to table attribute for mypy compatibility by @noambloom in https://github.com/kayak/pypika/pull/866
Full Changelog: https://github.com/kayak/pypika/compare/v0.51.0...v0.51.1
typefix: update parameter types in aggregate and function classes to use Term by @noambloom in https://github.com/kayak/pypika/pull/864
Full Changelog: https://github.com/kayak/pypika/compare/v0.50.0...v0.51.0
Your coding agent can read these notes before it upgrades. Set up the MCP server →
JQL (Jira Query Language) support - New JiraQuery class for building Jira queries with isempty() and notempty() methods
JiraQuery class for building Jira queries with isempty() and notempty() methods (#721)bitwiseor() method on fields (#825)distinct_on() method for ClickHouse queries (#817)limit_by() and limit_offset_by() methods (#817)final() method for FINAL keyword (#765)sample() method for approximate query processing (#707)limit() and offset() support using FETCH NEXT/OFFSET ROWS syntax (#754)Query.create_index() and Query.drop_index() with support for unique, partial, and conditional indices (#753)QueryBuilder.pipe() method for functional composition (#759)get_parameters() method to collect parameter values, ListParameter and DictParameter base classes (#794)datetime.time values (#837)EmptyCriterion handling in &, |, ^ operations with Criterion (#732)Field.__init__ to accept string table names (#742)isin() and notin() to accept frozenset (#744)py.typed marker for PEP 561 compliance (#666)@builder decorator to preserve callable type (#740)__all__ exports (#815)Interval to inherit from Term (#838)Criterion comparisons (#849)frozenset in the isin(...) and notin(...) functions by @antoninkriz in https://github.com/kayak/pypika/pull/744Field.__init__ by @WH-2099 in https://github.com/kayak/pypika/pull/742Full Changelog: https://github.com/kayak/pypika/compare/v0.48.9...v0.50.0
Bump version: 0.48.8 → 0.48.9
Bump version: 0.48.8 → 0.48.9
Bump version: 0.48.7 → 0.48.8
Bump version: 0.48.7 → 0.48.8
Bump version: 0.48.6 → 0.48.7
Bump version: 0.48.6 → 0.48.7
Bump version: 0.48.5 → 0.48.6
Bump version: 0.48.5 → 0.48.6
Bump version: 0.48.4 → 0.48.5
Bump version: 0.48.4 → 0.48.5
Bump version: 0.48.3 → 0.48.4
Bump version: 0.48.3 → 0.48.4
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
Nothing published for this version
One column per quarter.