Download Latest Version 1.33.0 source code.tar.gz (550.9 kB)
Email in envelope

Get an email when there's a new version of Piccolo

Home / 1.32.0
Name Modified Size InfoDownloads / Week
Parent folder
1.32.0 source code.tar.gz 2026-02-11 547.7 kB
1.32.0 source code.zip 2026-02-11 781.9 kB
README.md 2026-02-11 636 Bytes
Totals: 3 Items   1.3 MB 0

Added the having clause, which is useful when working with group_by.

For example, here we get the number of albums per band, but exclude any bands with less than 2 albums:

:::python
>>> from piccolo.query.functions.aggregate import Count

>>> await Album.select(
...     Album.band.name.as_alias('band_name'),
...     Count()
... ).group_by(
...     Album.band
... ).having(
...     Count() >= 2
... )

[
    {"band_name": "Pythonistas", "count": 2},
]

We also updated our CockroachDB support to the latest version (thanks to @sinisaos for this).

Source: README.md, updated 2026-02-11