ProtectedoptionsProtectedsequelizeOptionaloptions: AddColumnQueryOptionsOptionaloptions: ArithmeticQueryOptionsOptionaloptions: AttributeToSqlOptionsOptionaloptions: BulkInsertOptionsOptionalcolumnDefinitions: { [columnName: string]: NormalizedAttributeOptions<Model<any, any>> }Returns a query that commits a transaction.
Optional_options: CreateDatabaseQueryOptionsReturns a query that creates a savepoint.
Optionaloptions: CreateSchemaQueryOptionsOptionaloptions: CreateTableQueryOptionsGenerates an SQL query that drops a foreign key constraint.
The table or associated model.
The name of the foreign key constraint.
Use removeConstraintQuery instead.
Optionaloptions: DropSchemaQueryOptionsOptionaloptions: DropTableQueryOptionsEscapes a value (e.g. a string, number or date) as an SQL value (as opposed to an identifier).
The value to escape
The options to use when escaping the value
Escapes an array of values (e.g. strings, numbers or dates) as an SQL List of values.
The list of values to escape
Optionaloptions: EscapeOptionsOptionaloptions: { delimiter?: string; schema?: string }Optionaloptions: EscapeOptionsThe goal of this method is to execute the equivalent of json_unquote for the current dialect.
Generates a dialect-aware COUNT(*) wrapper around a subquery.
This utility is used to compute the total number of rows returned by an arbitrary SQL query by wrapping it in:
SELECT COUNT(*) AS count FROM (
The alias token is generated through getAliasToken, so dialects
that do not support the AS keyword (e.g. Oracle) are handled correctly.
The SQL query to wrap inside the COUNT(*) subquery.
const subQuery = `SELECT * FROM "Users" WHERE "active" = true`;
const countQuery = queryGenerator.generateCountAllQuery(subQuery);
// SELECT COUNT(*) AS count FROM (SELECT * FROM "Users" WHERE "active" = true) AS Z
// (Oracle)
// SELECT COUNT(*) AS count FROM (SELECT * FROM "Users" WHERE "active" = true) Z
Generates a unique identifier for the current transaction.
Generates an SQL query that returns all foreign keys of a table or the foreign key constraint of a given column.
The table or associated model.
Optional_columnName: stringThe name of the column. Not supported by SQLite.
The generated SQL query.
Use showConstraintsQuery instead.
OptionalcolumnDefinitions: { [columnName: string]: NormalizedAttributeOptions<Model<any, any>> }Optionaloptions: InsertOptions⚠️ This is not an identifier, it's a raw SQL expression. It will be inlined in the query.
The JSON path, where each item is one level of the path
Whether the result should be unquoted (depending on dialect: ->> and #>> operators, json_unquote function). Defaults to false.
Optional_options: ListDatabasesQueryOptionsOptional_options: ListSchemasQueryOptionsOptional_options: ListTablesQueryOptionsAdds quotes to identifier
Optional_force: booleanQuote table name with optional alias and schema attribution
table string or object
Optionaloptions: QuoteTableOptionsoptions
Optionaloptions: RemoveColumnQueryOptionsOptionaloptions: RemoveConstraintQueryOptionsOptional_options: RemoveIndexQueryOptionsOptionaloptions: RenameTableQueryOptionsReturns a query that rollbacks a savepoint.
Returns a query that rollbacks a transaction.
Optionaloptions: SelectOptions<M>Optionalmodel: ModelStatic<M>Optionalconstraints: readonly string[]Returns a query that sets the transaction isolation level.
Optional_options: ShowConstraintsQueryOptionsReturns a query that starts a transaction.
Optionaloptions: StartTransactionQueryOptionsOptional_options: TruncateTableQueryOptionsOptionaloptions: ParameterOptionsOptionalcolumnDefinitions: { [columnName: string]: NormalizedAttributeOptions<Model<any, any>> }Optionaloptions: FormatWhereOptionsOptionaloptions: FormatWhereOptions
The base class for all query generators, used to generate all SQL queries.
The implementation varies between SQL dialects, and is overridden by subclasses. You can access your dialect's version through Sequelize#queryGenerator.