Drizzle ORM Syntax Cheat Sheet

import { pgTable, serial, text, integer, timestamp } from "drizzle-orm/pg-core";
import { relations } from "drizzle-orm";

export const users = pgTable("users", {
  id: serial("id").primaryKey(),
  name: text("name").notNull(),
  email: text("email").notNull().unique(),
  createdAt: timestamp("created_at").defaultNow()
});

export const posts = pgTable("posts", {
  id: serial("id").primaryKey(),
  title: text("title").notNull(),
  authorId: integer("author_id").references(() => users.id, { onDelete: "cascade" })
});

// Relational API mapping
export const usersRelations = relations(users, ({ many }) => ({
  posts: many(posts)
}));

import { db } from "./db";
import { users, posts } from "./schema";
import { eq, like, desc } from "drizzle-orm";

// 1. Select with SQL expressions
const activeUsers = await db
  .select({ id: users.id, name: users.name })
  .from(users)
  .where(like(users.email, "%@example.com"))
  .orderBy(desc(users.createdAt))
  .limit(10);

// 2. Relational Query API
const result = await db.query.users.findMany({
  where: eq(users.id, 1),
  with: {
    posts: true
  }
});

// 3. Insert record
await db.insert(users).values({
  name: "Bob",
  email: "bob@example.com"
});