notbugAs an Amazon Associate I earn from qualifying purchases.
Want a good read? Try FreeBSD Mastery: Jails (IT Mastery Book 15)
Want a good monitor light? See my photos
All times are UTC
Ukraine
The recently imposed "must be logged in" restriction is a response to increased bot traffic on the site. This affects search, commits, and vuxml pages.
Search engines are not blocked. Try using "site:www.freshports.org" and your search terms.
Port details
py-PyPika SQL query builder API for Python
0.51.1 databasesnew! on this many watch lists=0 search for ports that depend on this port Find issues related to this port Report an issue related to this port View this port on Repology. pkg-fallout Package not present on quarterly.This port was created during this quarter. It will be in the next quarterly branch but not the current one.
Maintainer: yuri@FreeBSD.org search for ports maintained by this maintainer
Port Added: 2026-07-14 01:00:14
Last Update: 2026-07-14 00:57:32
Commit Hash: 845b55d
Also Listed In: python
License: APACHE20
WWW:
https://github.com/kayak/pypika
Description:
PyPika is a SQL query builder API for Python. It constructs SQL queries using a fluent, Python-native interface.
Homepage    cgit ¦ Codeberg ¦ GitHub ¦ GitLab ¦ SVNWeb - no subversion history for this port

Manual pages:
FreshPorts has no man page information for this port.
pkg-plist: as obtained via: make generate-plist
There is no configure plist information for this port.
USE_RC_SUBR (Service Scripts)
  • no SUBR information found for this port
Dependency lines:
  • ${PYTHON_PKGNAMEPREFIX}PyPika>0:databases/py-PyPika@${PY_FLAVOR}
To install the port:
cd /usr/ports/databases/py-PyPika/ && make install clean
To add the package, run one of these commands:
  • pkg install databases/py-PyPika
  • pkg install py312-PyPika
NOTE: If this package has multiple flavors (see below), then use one of them instead of the name specified above.
NOTE: This is a Python port. Instead of py312-PyPika listed in the above command, you can pick from the names under the Packages section.
PKGNAME: py312-PyPika
Package flavors (<flavor>: <package>)
  • py312: py312-PyPika
distinfo:
TIMESTAMP = 1783977767 SHA256 (pypika-0.51.1.tar.gz) = c30c7c1048fbf056fd3920c5a2b88b0c29dd190a9b2bee971fd17e4abe4d0ebe SIZE (pypika-0.51.1.tar.gz) = 80919

No package information for this port in our database
Sometimes this happens. Not all ports have packages. This is doubly so for new ports, like this one.
Dependencies
NOTE: FreshPorts displays only information on required and default dependencies. Optional dependencies are not covered.
Build dependencies:
  1. py312-setuptools>0 : devel/py-setuptools@py312
  2. py312-wheel>0 : devel/py-wheel@py312
  3. python3.12 : lang/python312
  4. py312-build>=0 : devel/py-build@py312
  5. py312-installer>=0 : devel/py-installer@py312
Test dependencies:
  1. python3.12 : lang/python312
Runtime dependencies:
  1. python3.12 : lang/python312
There are no ports dependent upon this port

Configuration Options:
No options to configure
Options name:
databases_py-PyPika
USES:
python
FreshPorts was unable to extract/find any pkg message
Master Sites:
Expand this list (2 items)
Collapse this list.
  1. https://files.pythonhosted.org/packages/source/p/pypika/
  2. https://pypi.org/packages/source/p/pypika/
Collapse this list.

Number of commits found: 1

Commit History - (may be incomplete: for full details, see links to repositories near top of page)
CommitCreditsLog message
0.51.1
14 Jul 2026 00:57:32
commit hash: 845b55d6eccb48714d3f7eade982986d51717cb6commit hash: 845b55d6eccb48714d3f7eade982986d51717cb6commit hash: 845b55d6eccb48714d3f7eade982986d51717cb6commit hash: 845b55d6eccb48714d3f7eade982986d51717cb6 files touched by this commit
Yuri Victorovich (yuri) search for other commits by this committer
databases/py-PyPika: New port: SQL query builder API for Python

Number of commits found: 1