Interface SetSessionVariablesOptions

Pass query execution time in milliseconds as second argument to logging function (options.logging).

Either an object of named parameter bindings in the format $param or an array of unnamed values to bind to $1, $2, etc in your SQL.

The connection on which this query must be run. Mutually exclusive with Transactionable.transaction.

Can be used to ensure that a query is run on the same connection as a previous query, which is useful when configuring session options.

Specifying this option takes precedence over CLS Transactions. If a transaction is running in the current AsyncLocalStorage context, it will be ignored in favor of the specified connection.

Map returned fields to arbitrary names for SELECT query type if options.fieldMaps is present.

A sequelize instance used to build the return instance

A function that gets executed while running the query to log the sql.

Map returned fields to model's fields if options.model or options.instance is present. Mapping will occur before building the model instance.

If true, transforms objects with . separated property names into nested objects using dottie.js. For example { 'user.username': 'john' } becomes { user: { username: 'john' }}. When nest is true, the query type is assumed to be 'SELECT', unless otherwise specified

Either an object of named parameter replacements in the format :param or an array of unnamed replacements to replace ? in your SQL.

If false do not prepend the query with the search_path (Postgres only)

The transaction in which this query must be run. Mutually exclusive with Transactionable.connection.

If the Sequelize disableClsTransactions option has not been set to true, and a transaction is running in the current AsyncLocalStorage context, that transaction will be used, unless null or another Transaction is manually specified here.

Force the query to use the write pool, regardless of the query type.