EmberORM

A Prisma-like ORM for Firebird, written in TypeScript. Schema language, database introspection (db pull), generated typed client, and an object-based query API (where, select, include, orderBy, aggregations, transactions).

npm install ember-orm

Quick start

# 1. scaffold a schema
npx ember init

# 2. point it at your database
export DATABASE_URL="firebird://SYSDBA:masterkey@localhost:3050//var/lib/firebird/app.fdb"

# 3. import an existing database into the schema
npx ember db pull

# 4. generate the typed client
npx ember generate

import { EmberClient } from "./generated";

const db = new EmberClient();
await db.$connect();

const users = await db.user.findMany({
  where: { active: true, email: { endsWith: "@acme.com" } },
  include: { posts: { where: { published: true } } },
  orderBy: { createdAt: "desc" },
  take: 20,
});

await db.$transaction(async (tx) => {
  const u = await tx.user.create({ data: { email: "a@b.com", name: "Ada" } });
  await tx.post.create({ data: { title: "Hi", author: { connect: { id: u.id } } } });
});

Schema example

datasource db {
  provider = "firebird"
  url      = env("DATABASE_URL")
}

generator client {
  provider = "ember-client-js"
  output   = "../generated"
}

model User {
  id        Int      @id @default(autoincrement())
  email     String   @unique @db.VarChar(255)
  name      String?
  posts     Post[]
  createdAt DateTime @default(now()) @map("CREATED_AT")

  @@map("USERS")
}

model Post {
  id       Int    @id @default(autoincrement())
  title    String
  author   User   @relation(fields: [authorId], references: [id], onDelete: Cascade)
  authorId Int    @map("AUTHOR_ID")
}

Feature overview

Editor support

A VSCode extension lives in editors/vscode — a Prisma-like experience for .ember files, powered by a dedicated language server: syntax highlighting, as-you-type diagnostics, canonical formatting with relation auto-completion (and format-on-save), go-to-definition, find references, rename, outline symbols, code actions, and context-aware completion (keywords, types, model/enum names, @/@@ attributes, @db.* native types, functions).

cd editors/vscode && npm install && npm run build   # then press F5 in VSCode

Editor tooling consumes the driver-free ember-orm/editor entry point (schema parser, validator, printer — no database driver).

Documentation

See /doc for the architecture, schema language, query API, and the Firebird-specific notes (identifier casing, transactions, pagination).

Safety

Every value is bound as a parameter (?) — identifiers are quoted and values are never string-interpolated. Every operation runs inside a transaction.