# Drizzle V1

> Drizzle ORM v1 RC upgrade and migration patterns. Use when upgrading drizzle-orm/drizzle-kit to v1 (beta), migrating from Relational Queries v1 to v2, updating relations schema definitions, or working with new v1 features like `through` for many-to-many relations and object-based `where`/`orderBy` syntax.

- Skill: `habibium/drizzle-v1` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds@latest add habibium/drizzle-v1`
- Raw SKILL.md: https://api.skillmd.com/api/skills/habibium/drizzle-v1/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Coding & Dev Tools
- Author: habibium (https://skillmd.com/u/habibium)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/habibium/drizzle-v1

---


# Drizzle ORM v1 RC Upgrade Guide

## Installation

```bash
npm i drizzle-orm@beta drizzle-kit@beta -D
```

## Upgrade Steps

### Step 1: Run `drizzle-kit up`

Migrate previous migrations folder to new format (removes `journal.json`, groups SQL files and snapshots):

```bash
npx drizzle-kit up
```

### Step 2: Update Relational Queries to v2

See [references/relational-queries-v2.md](references/relational-queries-v2.md) for complete migration patterns.

## Quick Reference: Key Changes

### Relations Definition

**v1** - Separate `relations()` calls for each table:
```typescript
import { relations } from "drizzle-orm/_relations"; // Note: moved import
export const usersRelation = relations(users, ({ one, many }) => ({
  posts: many(posts),
}));
```

**v2** - Single `defineRelations()` for all tables:
```typescript
import { defineRelations } from "drizzle-orm";
import * as schema from "./schema";

export const relations = defineRelations(schema, (r) => ({
  users: {
    posts: r.many.posts({
      from: r.users.id,
      to: r.posts.authorId,
    }),
  },
}));
```

### Database Instance

**v1:**
```typescript
const db = drizzle(url, { schema, mode: "planetscale" });
```

**v2** - No `mode` needed, use `relations`:
```typescript
import { relations } from './relations';
const db = drizzle(url, { relations });
```

### Queries

**v1** - Function-based `where`/`orderBy`:
```typescript
await db.query.users.findMany({
  where: (users, { eq }) => eq(users.id, 1),
  orderBy: (users, { asc }) => [asc(users.id)],
});
```

**v2** - Object-based syntax:
```typescript
await db.query.users.findMany({
  where: { id: 1 },
  orderBy: { id: "asc" },
});
```

### Many-to-Many with `through`

**v2** (new feature):
```typescript
export const relations = defineRelations(schema, (r) => ({
  users: {
    groups: r.many.groups({
      from: r.users.id.through(r.usersToGroups.userId),
      to: r.groups.id.through(r.usersToGroups.groupId),
    }),
  },
}));
```

### Partial Upgrade (Keep RQB v1)

Use old syntax while migrating gradually:
1. Import from `drizzle-orm/_relations`
2. Use `db._query` instead of `db.query`

## v2 Filter Operators

Object-based filters with `AND`, `OR`, `NOT`, `RAW`:

```typescript
await db.query.users.findMany({
  where: {
    AND: [
      { OR: [{ name: { like: "John%" } }, { name: { ilike: "jane%" } }] },
      { age: { gt: 18 } },
      { NOT: { status: "banned" } },
      { RAW: (t) => sql`${t.createdAt} > NOW() - INTERVAL '30 days'` },
    ],
  },
});
```

## New Features in v2

- **`optional: false`** - Make relation required at type level
- **`through`** - Direct many-to-many without manual junction table queries
- **Predefined filters** - `where` in relation definition
- **Relation filtering** - Filter parent by child properties
- **Offset on related objects** - Pagination in nested relations