| Index | index by Group | index by Distribution | index by Vendor | index by creation date | index by Name | Mirrors | Help | Search |
| Name: python313-PyPika | Distribution: openSUSE Tumbleweed |
| Version: 0.51.1 | Vendor: openSUSE |
| Release: 1.1 | Build date: Sat Feb 28 02:07:15 2026 |
| Group: Development/Libraries/Python | Build host: reproducible |
| Size: 677910 | Source RPM: python-PyPika-0.51.1-1.1.src.rpm |
| Packager: https://bugs.opensuse.org | |
| Url: https://github.com/kayak/pypika | |
| Summary: A SQL query builder API for Python | |
A SQL query builder API for Python. The motivation behind PyPika is to provide a simple interface for building SQL queries without limiting the flexibility of handwritten SQL. Designed with data analysis in mind, PyPika leverages the builder design pattern to construct queries to avoid messy string formatting and concatenation. It is also easily extended to take full advantage of specific features of SQL database vendors.
Apache-2.0
* Sat Feb 28 2026 Matej Cepl <mcepl@cepl.eu>
- Update to 0.51.1:
- typefix: Add explicit type annotations to table attribute for
mypy compatibility by @noambloom in #866
- Update to 0.51.0:
- typefix: update parameter types in aggregate and function
classes to use Term by @noambloom in #864
- Update to 0.50.0:
- New Features
- JQL (Jira Query Language) support - New JiraQuery class for
building Jira queries with isempty() and notempty() methods
(#721)
- QUALIFY clause - Filter rows based on window function
results (#841)
- Bitwise OR support - New bitwiseor() method on fields
(#825)
- ClickHouse DISTINCT ON - distinct_on() method for
ClickHouse queries (#817)
- ClickHouse LIMIT BY - limit_by() and limit_offset_by()
methods (#817)
- ClickHouse FINAL - final() method for FINAL keyword (#765)
- ClickHouse SAMPLE - sample() method for approximate query
processing (#707)
- Oracle LIMIT/OFFSET - limit() and offset() support using
FETCH NEXT/OFFSET ROWS syntax (#754)
- CREATE/DROP INDEX - Query.create_index() and
Query.drop_index() with support for unique, partial, and
conditional indices (#753)
- Pipe operator - QueryBuilder.pipe() method for functional
composition (#759)
- Improved parameterized queries - get_parameters() method to
collect parameter values, ListParameter and DictParameter
base classes (#794)
- Auto increment columns - Auto increment support on SqlTypes
for CREATE TABLE (#829)
- datetime.time support - Proper handling of datetime.time
values (#837)
- Bug Fixes
- Fixed EmptyCriterion handling in &, |, ^ operations with
Criterion (#732)
- Fixed Field.__init__ to accept string table names (#742)
- Fixed isin() and notin() to accept frozenset (#744)
- Fixed MySQL set operations (UNION/INTERSECT/MINUS) to wrap
queries in parentheses (#782)
- Fixed PostgreSQL array syntax for UPDATE statements (#644)
- Fixed escape quotes in identifiers (#811)
- Typing & Compatibility
- Added py.typed marker for PEP 561 compliance (#666)
- Fixed typing hint for @builder decorator to preserve
callable type (#740)
- Fixed types for mypy downstream usage, added __all__
exports (#815)
- Improved typing for builder methods (#850)
- Added Python 3.13 and 3.14 support (#848, #851)
- Applied future type style annotations (#853)
- Documentation
- Added comprehensive documentation for all new features to
README.rst
- Added documentation for: Analytic Queries (NTILE, RANK,
FIRST_VALUE, LAST_VALUE, MEDIAN, AVG, STDDEV), Window
Frames, ROLLUP, Pseudo Columns, TEMPORARY/UNLOGGED tables
- Unified documentation between README.rst and ReadTheDocs
(single source of truth)
- Fixed PseudoColumn import in docs (#698)
- Added contributing guidelines (#758)
- Various typo fixes (#695, #801, #804)
- Internal
- Refactored Interval to inherit from Term (#838)
- Refactored shared logic for Criterion comparisons (#849)
- Updated CI to test Python 3.8-3.14 and PyPy 3.9-3.11 on
Ubuntu and macOS
- Added GitHub Actions release workflow for PyPI publishing
- Removed tox dependency, simplified test running
- Updated Sphinx and other dev dependencies
* Tue Mar 25 2025 Steve Kowalik <steven.kowalik@suse.com>
- Lowercase metadata directory name.
* Fri Aug 30 2024 Meera Belur <mbelur@suse.com>
- Initial Package
/usr/lib/python3.13/site-packages/pypika /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info/INSTALLER /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info/METADATA /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info/RECORD /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info/REQUESTED /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info/WHEEL /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info/licenses /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info/licenses/LICENSE.txt /usr/lib/python3.13/site-packages/pypika-0.51.1.dist-info/top_level.txt /usr/lib/python3.13/site-packages/pypika/__init__.py /usr/lib/python3.13/site-packages/pypika/__pycache__ /usr/lib/python3.13/site-packages/pypika/__pycache__/__init__.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/__init__.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/analytics.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/analytics.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/dialects.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/dialects.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/enums.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/enums.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/functions.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/functions.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/pseudocolumns.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/pseudocolumns.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/queries.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/queries.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/terms.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/terms.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/utils.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/__pycache__/utils.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/analytics.py /usr/lib/python3.13/site-packages/pypika/clickhouse /usr/lib/python3.13/site-packages/pypika/clickhouse/__init__.py /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__ /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/__init__.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/__init__.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/array.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/array.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/condition.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/condition.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/dates_and_times.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/dates_and_times.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/nullable_arg.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/nullable_arg.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/search_string.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/search_string.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/type_conversion.cpython-313.opt-1.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/__pycache__/type_conversion.cpython-313.pyc /usr/lib/python3.13/site-packages/pypika/clickhouse/array.py /usr/lib/python3.13/site-packages/pypika/clickhouse/condition.py /usr/lib/python3.13/site-packages/pypika/clickhouse/dates_and_times.py /usr/lib/python3.13/site-packages/pypika/clickhouse/nullable_arg.py /usr/lib/python3.13/site-packages/pypika/clickhouse/search_string.py /usr/lib/python3.13/site-packages/pypika/clickhouse/type_conversion.py /usr/lib/python3.13/site-packages/pypika/dialects.py /usr/lib/python3.13/site-packages/pypika/enums.py /usr/lib/python3.13/site-packages/pypika/functions.py /usr/lib/python3.13/site-packages/pypika/pseudocolumns.py /usr/lib/python3.13/site-packages/pypika/py.typed /usr/lib/python3.13/site-packages/pypika/queries.py /usr/lib/python3.13/site-packages/pypika/terms.py /usr/lib/python3.13/site-packages/pypika/utils.py /usr/share/doc/packages/python313-PyPika /usr/share/doc/packages/python313-PyPika/README.rst /usr/share/licenses/python313-PyPika /usr/share/licenses/python313-PyPika/LICENSE.txt
Generated by rpm2html 1.8.1
Fabrice Bellet, Thu Mar 5 22:51:13 2026