Query Types

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 typical ORM.

Comparisons

If you’re familiar with other ORMs, here are some guides which show the Piccolo equivalents of common queries.