Relations and joins

Load related records in the same query, filter by them, and write through them.

Include a relation

const authors = await db.user.include({ posts: true }).all();

Filter by a relation

const prolific = await db.user.where({ posts: { some: { published: true } } }).all();

Nested writes

await db.user.create({
  data: { email: "sam@example.com", posts: { create: [{ title: "Hello" }] } },
});