> For the complete documentation index, see [llms.txt](https://clear.gitbook.io/project/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://clear.gitbook.io/project/querying.md).

# Querying

- [The collection object](https://clear.gitbook.io/project/querying/the-collection-object.md)
- [Filter the query](https://clear.gitbook.io/project/querying/the-collection-object/filter-the-query-1.md): Clear offers many tools to filter and refine your query
- [Filter the query – The Expression Engine](https://clear.gitbook.io/project/querying/the-collection-object/filter-the-query-1/filter-the-query.md)
- [Find, First, Last, Offset, Limit](https://clear.gitbook.io/project/querying/the-collection-object/filter-the-query-1/find-first.md)
- [Aggregation](https://clear.gitbook.io/project/querying/the-collection-object/filter-the-query-1/aggregation.md)
- [Ordering & Group by](https://clear.gitbook.io/project/querying/the-collection-object/filter-the-query-1/ordering.md)
- [Fetching the query](https://clear.gitbook.io/project/querying/the-collection-object/fetching-the-query.md)
- [Each and Fetch](https://clear.gitbook.io/project/querying/the-collection-object/fetching-the-query/each-map-fetch.md)
- [Cursored fetching](https://clear.gitbook.io/project/querying/the-collection-object/fetching-the-query/cursored-fetching.md)
- [Model extra attributes](https://clear.gitbook.io/project/querying/the-collection-object/fetching-the-query/model-attributes.md)
- [Joins](https://clear.gitbook.io/project/querying/the-collection-object/joins.md)
- [Eager Loading](https://clear.gitbook.io/project/querying/the-collection-object/n+1-query-avoidance.md)
- [Window and CTE](https://clear.gitbook.io/project/querying/the-collection-object/window-and-cte.md)
- [Scopes](https://clear.gitbook.io/project/querying/the-collection-object/scopes.md)
- [Writing low-level SQL](https://clear.gitbook.io/project/querying/low-level-sql.md)
- [Select Clause](https://clear.gitbook.io/project/querying/low-level-sql/select-clause.md)
- [Insert Clause](https://clear.gitbook.io/project/querying/low-level-sql/insert-clause.md)
- [Delete Clause](https://clear.gitbook.io/project/querying/low-level-sql/delete-clause.md)