Skip to content

MutationBuilder.where() method

Home > @direct-sqlite/core > MutationBuilder > where

Appends constraints limiting mutation target scopes.

Signature:

where<K extends keyof TRow>(column: K, operator: ComparisonOperator, value: TRow[K] | TRow[K][] | null): this;

Parameter

Type

Description

column

K

The column name to apply the WHERE condition on. Should be a key of the table’s row type.

operator

ComparisonOperator

The comparison operator to use in the WHERE condition. Should be one of the defined ComparisonOperator types.

value

TRow[K] | TRow[K][] | null

The value to compare against. Can be a single value, an array of values (for IN operator), or null (for IS/IS NOT operators).

Returns:

this