Drizzle vs Prisma Vergleich

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

const db = drizzle(postgres(DATABASE_URL));

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

// Abgeleiteter Typ: User[] aus dem Schema

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

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