{"library":"orchid-orm","type":"library","category":null,"description":"A TypeScript-first PostgreSQL ORM focused on type safety, performance, and developer experience. Current stable version 1.70.1, released with frequent updates (weekly/biweekly). Key differentiators: highly expressive query builder with full type inference, built-in support for relations (belongsTo, hasMany, etc.), migrations, and transaction management. Unlike many ORMs, it generates exact return types from database schema via introspection or manual table definitions, ensuring compile-time safety for queries. Ships with zero runtime dependencies besides TypeScript as a peer dependency, and provides first-class ESM support. Suitable for projects requiring robust type checking and complex SQL interactions without sacrificing performance.","language":"javascript","status":"active","version":"1.70.1","tags":["javascript","orm","pg","postgres","ts","typescript"],"last_verified":"Thu Jun 04","install":[{"cmd":"npm install orchid-orm","imports":["import { createORM } from 'orchid-orm'","import { createORM } from 'orchid-orm'","import { table } from 'orchid-orm'","import { InferSelect, InferInsert } from 'orchid-orm'"]},{"cmd":"yarn add orchid-orm","imports":[]},{"cmd":"pnpm add orchid-orm","imports":[]}],"homepage":"https://orchid-orm.netlify.app/guide/orm-and-query-builder.html","github":"https://github.com/romeerez/orchid-orm","docs":null,"changelog":null,"pypi":null,"npm":"orchid-orm","openapi_spec":null,"status_page":null,"smithery":null,"compatibility":null}