kern-ormFully typed query builder for PostgreSQL

Load related records in one SQL statement, run transactions without passing them around, and reuse tables across tenant schemas.

Get Started

Database without the ORM

GitHub

Fully typed

Query results and filters are inferred from table definitions.

Related records in one query

Select the related records of each row, at any depth, in a single SQL statement.

Schema per tenant

Reuse table definitions and queries across PostgreSQL schemas, such as tenant schemas and a shared application schema.

Ambient transactions

Queries join the current transaction without passing it around.

Tests in transactions

Run each test in a transaction that rolls back, with node:test, bun:test, or Vitest.

SQL when you need it

Add SQL conditions to queries, or run any SQL statement and get typed rows.

Migrations

Write migrations with helpers or SQL, and apply them to any PostgreSQL schema, such as the schema of each tenant.

Load forms with their fields in one SQL statement:

const forms = await db.form
  .where({ published: true })
  .select("id", "name")
  .select(form => ({
    fields: form.fields.select("id", "label"),
  }))
// forms: { id: string; name: string; fields: { id: string; label: string }[] }[]

See Related Records for filtering, nesting, and reusing related records.