$devvkit learn --librarie drizzle-orm-guide

Drizzle ORM Guide

[orm][database][typescript]

JavaScript / TypeScript

Install

npm install drizzle-orm @libsql/client
npm install -D drizzle-kit
npx drizzle-kit init

Drizzle is a thin SQL-like query builder. Define schema with TypeScript types, not a DSL.

Every query maps directly to SQL. No hidden ORM magic or N+1 surprises.

drizzle-kit generates clean, human-readable SQL migration files.

Schema Definition

Define table· SQLite table schema.

import { sqliteTable, text, integer } from 'drizzle-orm/sqlite-core';
export const users = sqliteTable('users', {
  id: integer('id').primaryKey({autoIncrement: true}),
  name: text('name').notNull(),
  email: text('email').unique().notNull(),
});

Define relation· Link tables.

import { relations } from 'drizzle-orm';
export const usersRelations = relations(users, ({ many }) => ({ posts: many(posts) }));

Queries

SELECT· Query with conditions.

import { eq, and, gte } from 'drizzle-orm';
const result = await db.select().from(users).where(and(eq(users.role,'admin'),gte(users.age,18)));

SELECT columns· Specific fields.

await db.select({id:users.id, name:users.name}).from(users);

Relations

JOIN· Join tables.

await db.select().from(users).leftJoin(posts, eq(users.id, posts.authorId));

Mutations

INSERT· Insert and return.

await db.insert(users).values({name:'Alice', email:'alice@example.com'}).returning();

UPDATE· Modify rows.

await db.update(users).set({name:'Updated'}).where(eq(users.id, 1));

DELETE· Remove rows.

await db.delete(users).where(eq(users.id, 1));

Migrations

Generate migration· Create SQL file.

npx drizzle-kit generate

Apply migration· Run pending migrations.

npx drizzle-kit migrate

Advanced

Prepared statement· Reuse query plan.

const stmt = db.select().from(users).where(eq(users.role,'admin')).prepare();
const admins = await stmt.execute();