InsertBuilder

InsertBuilder = object

Defined in: packages/db/src/types.ts:463

Builder for insert operations on a single table.

Returned by db.insert(table). Chain .values() to set the row data, then optionally .returning() to get the inserted row back.

Example

// Insert without returning
await db.insert(posts).values({ title: "Hello", authorId: user.id }).run({});

// Insert with returning
const row = await db.insert(posts)
  .values({ title: "Hello", authorId: user.id })
  .returning()
  .run({});

Properties

values()

values: (values) => InsertReturningBuilder

Defined in: packages/db/src/types.ts:465

Specifies the column values to insert, returning an InsertReturningBuilder.

Parameters

values

Record<string, unknown>

Returns

InsertReturningBuilder