Relations

One-to-many

A column with references() creates a one-to-many relation. The client exposes it in both directions.

const project = await db.projects.find(id, {  with: { tasks: { where: { done: false } } },})// project.tasks: Task[]

Many-to-many

Define a join table with two references. Tessera recognises the pattern and adds a through helper.

export const memberships = table("memberships", {  userId: uuid().references(() => users.id),  projectId: uuid().references(() => projects.id),}).primaryKey("userId", "projectId")

Loading strategy

Nested with clauses compile to a single SQL query using lateral joins, so loading relations never causes N+1 requests.