The type-safe ORMwithout the generate step.

import { s } from "viborm";

export const user = s.model({
  id: s.string().id().ulid(),
  email: s.string().unique(),
  posts: s.oneToMany(() => post),
});

export const post = s.model({
  id: s.string().id().ulid(),
  title: s.string(),
  published: s.boolean().default(false),
  authorId: s.string(),
  author: s.manyToOne(() => user)
    .fields("authorId")
    .references("id"),
});

const authors = await client.user.findMany({
  where: {
    email: { contains: "@company.com" },
  },
  include: {
    posts: {
      where: { published: true },
      orderBy: { title: "asc" },
    },
  },
});