13 · Drizzle ORM (SQL-first)

• SQL-first, type-safe, minimal magic.
• Great fit for App Router when you want explicit queries.

npm install drizzle-orm better-sqlite3
npm install -D drizzle-kit

import { sqliteTable, text, integer } from "drizzle-orm/sqlite-core";

export const users = sqliteTable("users", {
  id: integer("id").primaryKey(),
  email: text("email").notNull(),
});

import Database from "better-sqlite3";
import { drizzle } from "drizzle-orm/better-sqlite3";

const sqlite = new Database("dev.db");
export const db = drizzle(sqlite);

await db.select().from(users);

• Swap driver; keep schema; run drizzle-kit generate.
• Maintain SQL-first workflow.