# Query

The query builder is used by the Database class to build SQL queries with a fluent API

****

- Full class name: `Kirby\Database\Query`
- Source: <https://github.com/getkirby/kirby/tree/5.5.3/src/Database/Query.php#L22>

****

### Query

- [$query->__call()](https://getkirby.com/docs/reference/objects/database/query/__call.md)
- [new Query()](https://getkirby.com/docs/reference/objects/database/query/__construct.md)
- [$query->aggregate()](https://getkirby.com/docs/reference/objects/database/query/aggregate.md)
- [$query->all()](https://getkirby.com/docs/reference/objects/database/query/all.md)
- [$query->andWhere()](https://getkirby.com/docs/reference/objects/database/query/and-where.md)
- [$query->avg()](https://getkirby.com/docs/reference/objects/database/query/avg.md)
- [$query->bindings()](https://getkirby.com/docs/reference/objects/database/query/bindings.md)
- [$query->build()](https://getkirby.com/docs/reference/objects/database/query/build.md)
- [$query->column()](https://getkirby.com/docs/reference/objects/database/query/column.md)
- [$query->count()](https://getkirby.com/docs/reference/objects/database/query/count.md)
- [$query->debug()](https://getkirby.com/docs/reference/objects/database/query/debug.md)
- [$query->delete()](https://getkirby.com/docs/reference/objects/database/query/delete.md)
- [$query->distinct()](https://getkirby.com/docs/reference/objects/database/query/distinct.md)
- [$query->fail()](https://getkirby.com/docs/reference/objects/database/query/fail.md)
- [$query->fetch()](https://getkirby.com/docs/reference/objects/database/query/fetch.md)
- [$query->find()](https://getkirby.com/docs/reference/objects/database/query/find.md)
- [$query->findBy()](https://getkirby.com/docs/reference/objects/database/query/find-by.md)
- [$query->first()](https://getkirby.com/docs/reference/objects/database/query/first.md)
- [$query->group()](https://getkirby.com/docs/reference/objects/database/query/group.md)
- [$query->having()](https://getkirby.com/docs/reference/objects/database/query/having.md)
- [$query->innerJoin()](https://getkirby.com/docs/reference/objects/database/query/inner-join.md)
- [$query->insert()](https://getkirby.com/docs/reference/objects/database/query/insert.md)
- [$query->iterator()](https://getkirby.com/docs/reference/objects/database/query/iterator.md)
- [$query->join()](https://getkirby.com/docs/reference/objects/database/query/join.md)
- [$query->leftJoin()](https://getkirby.com/docs/reference/objects/database/query/left-join.md)
- [$query->limit()](https://getkirby.com/docs/reference/objects/database/query/limit.md)
- [$query->max()](https://getkirby.com/docs/reference/objects/database/query/max.md)
- [$query->min()](https://getkirby.com/docs/reference/objects/database/query/min.md)
- [$query->offset()](https://getkirby.com/docs/reference/objects/database/query/offset.md)
- [$query->one()](https://getkirby.com/docs/reference/objects/database/query/one.md)
- [$query->orWhere()](https://getkirby.com/docs/reference/objects/database/query/or-where.md)
- [$query->order()](https://getkirby.com/docs/reference/objects/database/query/order.md)
- [$query->page()](https://getkirby.com/docs/reference/objects/database/query/page.md)
- [$query->primaryKeyName()](https://getkirby.com/docs/reference/objects/database/query/primary-key-name.md)
- [$query->rightJoin()](https://getkirby.com/docs/reference/objects/database/query/right-join.md)
- [$query->row()](https://getkirby.com/docs/reference/objects/database/query/row.md)
- [$query->select()](https://getkirby.com/docs/reference/objects/database/query/select.md)
- [$query->sum()](https://getkirby.com/docs/reference/objects/database/query/sum.md)
- [$query->table()](https://getkirby.com/docs/reference/objects/database/query/table.md)
- [$query->update()](https://getkirby.com/docs/reference/objects/database/query/update.md)
- [$query->values()](https://getkirby.com/docs/reference/objects/database/query/values.md)
- [$query->where()](https://getkirby.com/docs/reference/objects/database/query/where.md)