drizzle-orm

Drizzle ORM is a lightweight, type-safe TypeScript ORM that maps directly to SQL for PostgreSQL, MySQL, and SQLite. It provides both a SQL-like query builder and a relational queries API, with zero dependencies and full serverless compatibility. Use Drizzle when you need compile-time type safety with SQL-level control; avoid it when you need a full active-record ORM with automatic migrations (use Prisma) or when w...

| Schema definition | pgTable('name', { columns }, (t) => [indexes]) | Third arg returns array of indexes/constraints | | Column types | text(), integer(), boolean(), timestamp() | Import from drizzle-orm/pg-core | | Type inference | typeof table.$inferSelect, $inferInsert | Derive TS types directly from schema |

| Relational queries | db.query.table.findMany({ with, where }) | Requires schema passed to drizzle() client | | SQL-like queries | db.select().from(table).where() | Chainable, returns array of rows | | Insert | db.insert(table).values({}).returning() | .returning() for getting inserted rows |