Drizzle vs Prisma Comparison

import { drizzle } from "drizzle-orm/postgres-js";
import { users } from "./schema";
import { eq } from "drizzle-orm";

const db = drizzle(postgres(DATABASE_URL));

// Type-safe SQL-like
const user = await db.select()
    .from(users)
    .where(eq(users.id, "123"))
    .limit(1);

// Inferred type: User[] from schema

// schema.prisma
model User {
    id       String  @id @default(cuid())
    email    String  @unique
    posts    Post[]
}

// Usage
const user = await prisma.user.findUnique({
    where: { id: "123" },
    include: { posts: true }
});