Drizzle ORM 1.0 (rc): relations() / Relational Queries v1 removed — use defineRelations + drizzle({ relations })

Before (0.x):

import { relations } from 'drizzle-orm'
export const usersRelations = relations(users, ({ many }) => ({ posts: many(posts) }))
export const postsRelations = relations(posts, ({ one }) => ({
  author: one(users, { fields: [posts.authorId], references: [users.id] }),
}))
const db = drizzle(process.env.DATABASE_URL!, { schema })
await db.query.users.findMany({ where: (u, { eq }) => eq(u.id, 1), orderBy: (u, { asc }) => [asc(u.id)] })

After (1.0):

import { defineRelations } from 'drizzle-orm'
import * as schema from './schema'
export const relations = defineRelations(schema, (r) => ({
  users: { posts: r.many.posts() },
  posts: { author: r.one.users({ from: r.posts.authorId, to: r.users.id }) },
}))
const db = drizzle(process.env.DATABASE_URL!, { relations })
await db.query.users.findMany({ where: { id: 1 }, orderBy: { id: 'asc' }, with: { posts: true } })

Operators: where: { id: { gt: 10 }, OR: [...], NOT: {...} }. Many-to-many: from: r.users.id.through(r.usersToGroups.userId) then with: { groups: true }. drizzle-kit pull can generate relations.ts in the new syntax. Other 1.0 API changes from the same guide: getTableColumns → getColumns, .enableRLS() → pgTable.withRLS(), column.array().array() → column.array('[][]'), drizzle-zod → drizzle-orm/zod.