Drizzle ORM Query Examples

import { db } from "./db";
import { modules, categories } from "./schema";
import { eq, and, desc } from "drizzle-orm";

// Paginated list
const list = await db.select()
  .from(modules)
  .where(and(eq(modules.isPublished, true), eq(modules.categorySlug, "devops")))
  .orderBy(desc(modules.publishedAt))
  .limit(20).offset(0);

// Insert
await db.insert(modules).values({ title: "New Module", slug: "new-module" });