drizzle-orm

name	drizzle-orm
description	Guidelines for developing with Drizzle ORM, a lightweight type-safe TypeScript ORM with SQL-like syntax

Drizzle ORM Development Guidelines

Query Patterns

Insert Operations

// Single insert
const newUser = await db
  .insert(users)
  .values({
    email: "[e-mail]",
    name: "John Doe",
  })
  .returning();

// Bulk insert
await db.insert(users).values([
  { email: "[e-mail]", name: "User 1" },
  { email: "[e-mail]", name: "User 2" },
]);

// Upsert (insert or update on conflict)
await db
  .insert(users)
  .values({ email: "[e-mail]", name: "John" })
  .onConflictDoUpdate({
    target: users.email,
    set: { name: "John Updated" },
  });