Orchid ORM

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.