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.

• Select
• Objects
• Count
• Alter
• Create Table
• Delete
• Exists
• Insert
• Raw
• Update

---

Features

• Transactions
• Joins

---

Comparisons

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

• Django Comparison