There are many different queries you can perform using Piccolo.
The main ways to query data are with Select, which returns data as
dictionaries, and Objects , which returns data as class instances, like a
If you’re familiar with other ORMs, here are some guides which show the Piccolo
equivalents of common queries.