Pattern — drizzle batch with dependent UUIDs

When to use

You need to atomically insert a parent row and one or more child rows that reference it. With drizzle-orm/neon-http, you cannot use db.transaction; you must use db.batch([...]) which queues statements upfront.

Pattern

Generate the parent UUID in application code so the child rows can reference it before the batch executes:

import { randomUUID } from 'node:crypto';

const projectId = randomUUID();

await db.batch([
  db.insert(schema.projects).values({ id: projectId, name: '...' }),
  db.insert(schema.transitions).values({
    id: randomUUID(),
    projectId,
    fromState: 'inbox',
    toState: 'triage',
  }),
]);

Gotchas

• The UUIDs must be RFC v4 if zod validation expects strict UUIDs (zod v4 default).
• db.batch returns one result per statement; index into the array if you need the inserted rows.
• Test mocks should return the same UUIDs you passed in — do not assume the DB generates them.

Reference

• Related canon entry: blockers/neon-http-transaction-trap
• Cross-project playbook: ~/.claude/playbooks/drizzle-orm.md