# Clear ORM

## Clear ORM

- [Welcome to Clear](https://clear.gitbook.io/project/readme.md)
- [Setup](https://clear.gitbook.io/project/introduction/installation.md)
- [Defining your model](https://clear.gitbook.io/project/model/column-types.md)
- [Describing your columns](https://clear.gitbook.io/project/model/column-types/model-definition.md)
- [Primary Keys](https://clear.gitbook.io/project/model/column-types/primary-keys.md)
- [Converters](https://clear.gitbook.io/project/model/column-types/converters.md)
- [Associations](https://clear.gitbook.io/project/model/associations.md): Relation describes the interaction between different models. Clear handles 4 type of relation: Belongs to, Has Many, Has Many Through and Has One.
- [belongs\_to](https://clear.gitbook.io/project/model/associations/belongs_to.md)
- [has\_many](https://clear.gitbook.io/project/model/associations/has_many.md)
- [has\_many through](https://clear.gitbook.io/project/model/associations/has_many-through.md)
- [has\_one](https://clear.gitbook.io/project/model/associations/has_one.md)
- [Lifecycle](https://clear.gitbook.io/project/model/lifecycle.md)
- [Persistence](https://clear.gitbook.io/project/model/lifecycle/persistence.md)
- [Validations](https://clear.gitbook.io/project/model/lifecycle/validations.md)
- [Triggers](https://clear.gitbook.io/project/model/lifecycle/callbacks.md)
- [Batchs operations](https://clear.gitbook.io/project/model/batchs-operations.md)
- [Bulk update](https://clear.gitbook.io/project/model/batchs-operations/bulk-update.md)
- [Bulk insert & delete](https://clear.gitbook.io/project/model/batchs-operations/bulk-insert.md)
- [Transactions & Save Points](https://clear.gitbook.io/project/model/transactions-and-save-points.md)
- [Transaction & Savepoints](https://clear.gitbook.io/project/model/transactions-and-save-points/transaction.md)
- [Connection pool](https://clear.gitbook.io/project/model/transactions-and-save-points/connection-pool.md)
- [Locks](https://clear.gitbook.io/project/model/locks.md)
- [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)
- [Manage migrations](https://clear.gitbook.io/project/migrations/manage-migrations.md)
- [Call migration script](https://clear.gitbook.io/project/migrations/call-migration-script.md)
- [Migration CLI](https://clear.gitbook.io/project/migrations/migration-cli.md)
- [JSONB](https://clear.gitbook.io/project/additional-and-advanced-features/jsonb.md)
- [Symbol vs String](https://clear.gitbook.io/project/additional-and-advanced-features/symbol-vs-string.md)
- [Enums](https://clear.gitbook.io/project/additional-and-advanced-features/enums.md)
- [BCrypt](https://clear.gitbook.io/project/additional-and-advanced-features/bcrypt.md)
- [Full Text Search](https://clear.gitbook.io/project/additional-and-advanced-features/full-text-search.md)
- [Handling multi-connection](https://clear.gitbook.io/project/additional-and-advanced-features/handling-multi-connection.md)
- [Benchmark](https://clear.gitbook.io/project/other-resources/benchmark.md)