drizzle-orm

Drizzle ORM is a TypeScript ORM that provides a SQL-like query builder with full type safety, zero overhead, and a philosophy of staying as close to SQL as possible while providing excellent TypeScript DX. Unlike Prisma's schema-first approach, Drizzle uses TypeScript table definitions as the source of truth, generating types directly from your schema code without code generation steps. The query builder's syntax mirrors SQL closely — select().from(users).where(eq(users.name, 'Alice')).leftJoin(posts, eq(posts.userId, users.id)) — making it intuitive for developers who know SQL. Drizzle supports PostgreSQL, MySQL, SQLite, and Turso with dialect-specific APIs that expose database-specific features rather than hiding them behind an abstraction. The Relational Query API provides a higher-level interface for nested data fetching similar to Prisma's include. Drizzle Kit handles schema migrations, introspection from existing databases, and studio-like database browsing. The ORM has zero runtime dependencies for the core package and produces minimal overhead compared to raw SQL. Drizzle's serverless-first design makes it particularly well-suited for edge and serverless environments where cold start time and bundle size matter.