INSERT Queries
This guide assumes you understand how to create models.
UPDATE Queries
This guide assumes you understand how to create models.
DELETE Queries
This guide assumes you understand how to create models.
SELECT Queries: Finder Methods
Finder methods are the ones that generate SELECT queries. All of the following methods are methods available on Model classes, and can be called on any model.
SELECT Queries: In Depth
In Finder Methods, we've seen what the various finder methods are. In this guide,
Operators
Sequelize provides a large number of operators to help you build complex queries. They are available in the Op object, which can be imported from @sequelize/core.
Raw SQL (literals)
We believe that ORMs are inherently leaky abstractions. They are a compromise between the flexibility of SQL and the convenience of an object-oriented programming language.
Querying JSON
<SupportTable
Subqueries
Subqueries are queries that are nested inside another query. They are a powerful tool that can be used to achieve complex queries that would otherwise be impossible to write.
Transactions
Sequelize supports transactions out of the box and offers two ways of using transactions: