Querying Basics

Sequelize Dart provides a comprehensive API for interacting with your database. This section covers all aspects of data retrieval and manipulation.

Use the sidebar or the links below to navigate the querying documentation.

• Select (Reading Data): Learn how to fetch data using findAll, findOne, and eager loading with include.
• Insert (Creating Data): Creating records, including nested creation.
• Update (Modifying Data): Bulk updates and instance updates.
• Delete (Destroying Data): Soft deletes, hard deletes, truncate, and restore operations.
• Instance Methods: Methods available on model instances like save(), reload(), destroy(), and restore().
• Query Conditions: Detailed guide on where clauses, operators, and logical combinations.
• JSON Querying: Defining JSON columns, navigating keys and arrays, containment checks, and combining conditions.
• Sorting & Pagination: Ordering results and handling pagination.
• Aggregations & Utilities: Count, sum, and other database utilities.
• Enums: Type-safe enum column querying with prefix shortcuts and grouped access.
• Transactions: Managed and unmanaged transactions, automatic inheritance via Dart Zones, and nested transaction patterns.