Mutations

Insert

await db
	.insert("users")
	.values({
		email: "alice@example.com",
		name: "Alice",
		createdAt: new Date("2026-01-01T00:00:00.000Z"),
	})
	.execute();

Batch insert:

await db.insert("users").values([
	{ email: "alice@example.com", name: "Alice", createdAt: new Date("2026-01-01T00:00:00.000Z") },
	{ email: "bob@example.com", name: "Bob", createdAt: new Date("2026-01-02T00:00:00.000Z") },
]).execute();

Update

await db
	.update("users")
	.where(({ users }) => users.id.eq(1, db.dialect))
	.set({ name: "Alice Updated" })
	.execute();

Delete

await db
	.delete("users")
	.where(({ users }) => users.id.eq(5, db.dialect))
	.execute();

Notes

• Mutation builders support .compile() and .execute().
• insert.values(...) requires at least one row.
• update.set(...) requires at least one column.
• Multiple .where(...) calls combine with and.