Prisma Next: Contract-first TypeScript ORM

model User {
  id    Int     @id @default(autoincrement())
  email String  @unique
  name  String?
}

model Post {
  id      Int    @id @default(autoincrement())
  title   String
  userId  Int
}

import postgres from '@prisma-next/postgres/runtime'
import type { Contract } from './.prisma/contract.d'
import contractJson from './.prisma/contract.json' with { type: 'json' }

export const db = postgres<Contract>({ contractJson })

// SQL DSL
const users = await db.sql.user
  .select('id', 'email')
  .limit(10)
  .build()

// ORM client
const posts = await db.orm.Post
  .where((p) => p.userId.eq(userId))
  .include('author')
  .all()