Function patch

patch<T = Record<string, unknown>>(
    key: string,
    table: string,
    id: string | number,
    values: ColumnValues,
    options?: IdColumnOptions,
): Promise<QueryResult<T>>
Convenience wrapper over updateRow that scopes the update to a single id (WHERE idColumn = id).
Type Parameters
- T = Record<string, unknown>
  Type of returned rows when RETURNING is used
Parameters
- key: string
  Primary key used for shard routing
- table: string
  Target table name
- id: string | number
  Primary-key value to match
- values: ColumnValues
  Column to value map of changes to apply
- options: IdColumnOptions = {}
  idColumn (default id) and returning
Returns Promise<QueryResult<T>>
The write result
Since
1.2.4
Example
```
await patch('42', 'tickets', 42, { status: 'closed', priority: 'high' });
```
- Defined in src/router.ts:3136