# Querying

- [The collection object](/project/querying/the-collection-object.md)
- [Filter the query](/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](/project/querying/the-collection-object/filter-the-query-1/filter-the-query.md)
- [Find, First, Last, Offset, Limit](/project/querying/the-collection-object/filter-the-query-1/find-first.md)
- [Aggregation](/project/querying/the-collection-object/filter-the-query-1/aggregation.md)
- [Ordering & Group by](/project/querying/the-collection-object/filter-the-query-1/ordering.md)
- [Fetching the query](/project/querying/the-collection-object/fetching-the-query.md)
- [Each and Fetch](/project/querying/the-collection-object/fetching-the-query/each-map-fetch.md)
- [Cursored fetching](/project/querying/the-collection-object/fetching-the-query/cursored-fetching.md)
- [Model extra attributes](/project/querying/the-collection-object/fetching-the-query/model-attributes.md)
- [Joins](/project/querying/the-collection-object/joins.md)
- [Eager Loading](/project/querying/the-collection-object/n+1-query-avoidance.md)
- [Window and CTE](/project/querying/the-collection-object/window-and-cte.md)
- [Scopes](/project/querying/the-collection-object/scopes.md)
- [Writing low-level SQL](/project/querying/low-level-sql.md)
- [Select Clause](/project/querying/low-level-sql/select-clause.md)
- [Insert Clause](/project/querying/low-level-sql/insert-clause.md)
- [Delete Clause](/project/querying/low-level-sql/delete-clause.md)