# Class SQLiteUpdateBase<TTable, TResultType, TRunResult, TFrom, TReturning, TDynamic, TExcludedMethods>

#### Type Parameters

- TTable extends SQLiteTable = SQLiteTable
- TResultType extends "sync" | "async" = "sync" | "async"
- TRunResult = unknown
- TFrom extends SQLiteTable | Subquery | SQLiteViewBase | SQL | undefined = undefined
- TReturning = undefined
- TDynamic extends boolean = false
- TExcludedMethods extends string = never

#### Hierarchy

- SQLWrapper
- QueryPromise<TReturning extends undefined ? TRunResult : TReturning[]>
  - SQLiteUpdateBase

#### Implements

- RunnableQuery<
  TReturning extends undefined ? TRunResult : TReturning[],
  "sqlite",
  >
- SQLWrapper

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:58
- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:71

##### Index

### Constructors

constructor

### Properties

_
[toStringTag]
all
fullJoin
get
innerJoin
leftJoin
rightJoin
run
values
[entityKind]

### Methods

$dynamic
catch
execute
finally
from
getSQL
limit
orderBy
prepare
returning
shouldOmitSQLParens?
then
toSQL
where

## Constructors

### constructor

- new SQLiteUpdateBase<
  TTable extends SQLiteTable<TableConfig> = SQLiteTable<TableConfig>,
  TResultType extends "sync" | "async" = "sync" | "async",
  TRunResult = unknown,
  TFrom extends
  | SQLiteTable<TableConfig>
  | SQLiteViewBase<string, boolean, ColumnsSelection>
  | SQL<unknown>
  | Subquery<string, Record<string, unknown>>
  | undefined = undefined,
  TReturning = undefined,
  TDynamic extends boolean = false,
  TExcludedMethods extends string = never,
  >(
  table: TTable,
  set: UpdateSet,
  session: SQLiteSession<any, any, any, any>,
  dialect: SQLiteDialect,
  withList?: Subquery<string, Record<string, unknown>>[],
  ): SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >

  #### Type Parameters

  - TTable extends SQLiteTable<TableConfig> = SQLiteTable<TableConfig>
  - TResultType extends "sync" | "async" = "sync" | "async"
  - TRunResult = unknown
  - TFrom extends
    | SQLiteTable<TableConfig>
    | SQLiteViewBase<string, boolean, ColumnsSelection>
    | SQL<unknown>
    | Subquery<string, Record<string, unknown>>
    | undefined = undefined
  - TReturning = undefined
  - TDynamic extends boolean = false
  - TExcludedMethods extends string = never

  #### Parameters

  - table: TTable
  - set: UpdateSet
  - session: SQLiteSession<any, any, any, any>
  - dialect: SQLiteDialect
  - `Optional` withList: Subquery<string, Record<string, unknown>>[]

  #### Returns SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >

  Inherited from SQLWrapper.constructor

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:75

## Properties

### `Readonly`_

_: {
dialect: "sqlite";
dynamic: TDynamic;
excludedMethods: TExcludedMethods;
from: TFrom;
result: TReturning extends undefined ? TRunResult : TReturning[];
resultType: TResultType;
returning: TReturning;
runResult: TRunResult;
table: TTable;
}

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:59

### [toStringTag]

"[toStringTag]": string

Inherited from QueryPromise.[toStringTag]

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/query-promise.d.ts:4

### all

all: (
placeholderValues?: Record<string, unknown>,
) => Result<
TResultType,
TReturning extends undefined
? DrizzleTypeError<".all() cannot be used without .returning()">
: TReturning[],
>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:146

### fullJoin

fullJoin: SQLiteUpdateJoinFn<
SQLiteUpdateBase<
TTable,
TResultType,
TRunResult,
TFrom,
TReturning,
TDynamic,
TExcludedMethods,
>,
>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:81

### get

get: (
placeholderValues?: Record<string, unknown>,
) => Result<
TResultType,
TReturning extends undefined
? DrizzleTypeError<".get() cannot be used without .returning()">
: TReturning,
>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:147

### innerJoin

innerJoin: SQLiteUpdateJoinFn<
SQLiteUpdateBase<
TTable,
TResultType,
TRunResult,
TFrom,
TReturning,
TDynamic,
TExcludedMethods,
>,
>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:80

### leftJoin

leftJoin: SQLiteUpdateJoinFn<
SQLiteUpdateBase<
TTable,
TResultType,
TRunResult,
TFrom,
TReturning,
TDynamic,
TExcludedMethods,
>,
>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:78

### rightJoin

rightJoin: SQLiteUpdateJoinFn<
SQLiteUpdateBase<
TTable,
TResultType,
TRunResult,
TFrom,
TReturning,
TDynamic,
TExcludedMethods,
>,
>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:79

### run

run: (
placeholderValues?: Record<string, unknown>,
) => Result<TResultType, TRunResult>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:145

### values

values: (
placeholderValues?: Record<string, unknown>,
) => Result<
TResultType,
TReturning extends undefined
? DrizzleTypeError<".values() cannot be used without .returning()">
: any[][],
>

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:148

### `Static` `Readonly`[entityKind]

"[entityKind]": string

- Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:74

## Methods

### $dynamic

- $dynamic(): SQLiteUpdateDynamic<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  >

  #### Returns SQLiteUpdateDynamic<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  >

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:150

### catch

- catch<TResult = never>(
  onRejected?: ((reason: any) => TResult | PromiseLike<TResult>) | null,
  ): Promise<
  (TReturning extends undefined ? TRunResult : TReturning[])
  | TResult,
  >

  Attaches a callback for only the rejection of the Promise.

  #### Type Parameters

  - TResult = never

  #### Parameters

  - `Optional` onRejected: ((reason: any) => TResult | PromiseLike<TResult>) | null

  #### Returns Promise<(TReturning extends undefined ? TRunResult : TReturning[]) | TResult>

  A Promise for the completion of the callback.

  Inherited from QueryPromise.catch

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/query-promise.d.ts:5

### execute

- execute(): Promise<
  SQLiteUpdateExecute<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  >,
  >

  #### Returns Promise<
  SQLiteUpdateExecute<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  >,
  >

  Inherited from QueryPromise.execute

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:149

### finally

- finally(
  onFinally?: (() => void) | null,
  ): Promise<TReturning extends undefined ? TRunResult : TReturning[]>

  Attaches a callback that is invoked when the Promise is settled (fulfilled or rejected). The resolved value cannot be modified from the callback.

  #### Parameters

  - `Optional` onFinally: (() => void) | null

  #### Returns Promise<TReturning extends undefined ? TRunResult : TReturning[]>

  A Promise for the completion of the callback.

  Inherited from QueryPromise.finally

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/query-promise.d.ts:6

### from

- from<
  TFrom extends
  | SQLiteTable<TableConfig>
  | SQLiteViewBase<string, boolean, ColumnsSelection>
  | SQL<unknown>
  | Subquery<string, Record<string, unknown>>,
  >(
  source: TFrom,
  ): SQLiteUpdateWithJoins<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  TFrom,
  >

  #### Type Parameters

  - TFrom extends
    | SQLiteTable<TableConfig>
    | SQLiteViewBase<string, boolean, ColumnsSelection>
    | SQL<unknown>
    | Subquery<string, Record<string, unknown>>

  #### Parameters

  - source: TFrom

  #### Returns SQLiteUpdateWithJoins<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  TFrom,
  >

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:76

### getSQL

- getSQL(): SQL

  #### Returns SQL

  Inherited from SQLWrapper.getSQL

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sql/sql.d.ts:50

### limit

- limit(
  limit: number | Placeholder<string, any>,
  ): SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "limit",
  >

  #### Parameters

  - limit: number | Placeholder<string, any>

  #### Returns SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "limit",
  >

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:118

### orderBy

- orderBy(
  builder: (
  updateTable: TTable,
  ) => ValueOrArray<
  | SQL<unknown>
  | Aliased<unknown>
  | SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>,
  >,
  ): SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "orderBy",
  >

  #### Parameters

  - builder: (
    updateTable: TTable,
    ) => ValueOrArray<
    | SQL<unknown>
    | Aliased<unknown>
    | SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>,
    >

  #### Returns SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "orderBy",
  >

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:116
- orderBy(
  ...columns: (
  | SQL<unknown>
  | Aliased<unknown>
  | SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>
  )[],
  ): SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "orderBy",
  >

  #### Parameters

  - ...columns: (
    | SQL<unknown>
    | Aliased<unknown>
    | SQLiteColumn<ColumnBaseConfig<ColumnDataType, string>, {}, {}>
    )[]

  #### Returns SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "orderBy",
  >

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:117

### prepare

- prepare(): SQLiteUpdatePrepare<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  >

  #### Returns SQLiteUpdatePrepare<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  >

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:144

### returning

- returning(): SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TTable["$inferSelect"],
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  >

  Adds a `returning` clause to the query.

  Calling this method will return the specified fields of the updated rows. If no fields are specified, all fields will be returned.

  See docs: https://orm.drizzle.team/docs/update#update-with-returning

  #### Returns SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TTable["$inferSelect"],
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  >

  #### Example

      // Update all cars with the green color and return all fields
      const updatedCars: Car[] = await db.update(cars)
        .set({ color: 'red' })
        .where(eq(cars.color, 'green'))
        .returning();

      // Update all cars with the green color and return only their id and brand fields
      const updatedCarsIdsAndBrands: { id: number, brand: string }[] = await db.update(cars)
        .set({ color: 'red' })
        .where(eq(cars.color, 'green'))
        .returning({ id: cars.id, brand: cars.brand });

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:141
- returning<TSelectedFields extends SelectedFields>(
  fields: TSelectedFields,
  ): SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  {
  [K in string
  | number
  | symbol]: {
  [Key in string | number | symbol]: SelectResultField<
  TSelectedFields[Key],
  true,
  >
  }[K]
  },
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "returning",
  >

  Adds a `returning` clause to the query.

  Calling this method will return the specified fields of the updated rows. If no fields are specified, all fields will be returned.

  See docs: https://orm.drizzle.team/docs/update#update-with-returning

  #### Type Parameters

  - TSelectedFields extends SelectedFields

  #### Parameters

  - fields: TSelectedFields

  #### Returns SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  {
  [K in string
  | number
  | symbol]: {
  [Key in string | number | symbol]: SelectResultField<
  TSelectedFields[Key],
  true,
  >
  }[K]
  },
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "returning",
  >

  #### Example

      // Update all cars with the green color and return all fields
      const updatedCars: Car[] = await db.update(cars)
        .set({ color: 'red' })
        .where(eq(cars.color, 'green'))
        .returning();

      // Update all cars with the green color and return only their id and brand fields
      const updatedCarsIdsAndBrands: { id: number, brand: string }[] = await db.update(cars)
        .set({ color: 'red' })
        .where(eq(cars.color, 'green'))
        .returning({ id: cars.id, brand: cars.brand });

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:142

### `Optional` shouldOmitSQLParens

- shouldOmitSQLParens?(): boolean

  #### Returns boolean

  Inherited from SQLWrapper.shouldOmitSQLParens

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sql/sql.d.ts:51

### then

- then<
  TResult1 = TReturning extends undefined ? TRunResult : TReturning[],
  TResult2 = never,
  >(
  onFulfilled?:
  | (
  (
  value: TReturning extends undefined ? TRunResult : TReturning[],
  ) => TResult1 | PromiseLike<TResult1>
  )
  | null,
  onRejected?: ((reason: any) => TResult2 | PromiseLike<TResult2>) | null,
  ): Promise<TResult1 | TResult2>

  Attaches callbacks for the resolution and/or rejection of the Promise.

  #### Type Parameters

  - TResult1 = TReturning extends undefined ? TRunResult : TReturning[]
  - TResult2 = never

  #### Parameters

  - `Optional` onFulfilled:
    | (
    (
    value: TReturning extends undefined ? TRunResult : TReturning[],
    ) => TResult1 | PromiseLike<TResult1>
    )
    | null
  - `Optional` onRejected: ((reason: any) => TResult2 | PromiseLike<TResult2>) | null

  #### Returns Promise<TResult1 | TResult2>

  A Promise for the completion of which ever callback is executed.

  Inherited from QueryPromise.then

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/query-promise.d.ts:7

### toSQL

- toSQL(): Query

  #### Returns Query

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:143

### where

- where(
  where: SQL<unknown> | undefined,
  ): SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "where",
  >

  Adds a 'where' clause to the query.

  Calling this method will update only those rows that fulfill a specified condition.

  See docs: https://orm.drizzle.team/docs/update

  #### Parameters

  - where: SQL<unknown> | undefined

    the 'where' clause.

  #### Returns SQLiteUpdateWithout<
  SQLiteUpdateBase<
  TTable,
  TResultType,
  TRunResult,
  TFrom,
  TReturning,
  TDynamic,
  TExcludedMethods,
  >,
  TDynamic,
  "where",
  >

  #### Example

  You can use conditional operators and `sql function` to filter the rows to be updated.

      // Update all cars with green color
      db.update(cars).set({ color: 'red' })
        .where(eq(cars.color, 'green'));
      // or
      db.update(cars).set({ color: 'red' })
        .where(sql`${cars.color} = 'green'`)

  You can logically combine conditional operators with `and()` and `or()` operators:

      // Update all BMW cars with a green color
      db.update(cars).set({ color: 'red' })
        .where(and(eq(cars.color, 'green'), eq(cars.brand, 'BMW')));

      // Update all cars with the green or blue color
      db.update(cars).set({ color: 'red' })
        .where(or(eq(cars.color, 'green'), eq(cars.color, 'blue')));

  - Defined in node_modules/.pnpm/drizzle-orm@0.44.6_@cloudflare+workers-types@4.20251014.0_@opentelemetry+api@1.9.0_@typ_31a6f5ca8f102af87864dd251ed08d88/node_modules/drizzle-orm/sqlite-core/query-builders/update.d.ts:115