Objection.js is a relational query builder for Node.js that prioritizes SQL expressiveness while providing convenient abstractions for common operations.
The tool solves the problem of bridging the gap between traditional ORMs and raw SQL by treating queries as first-class objects rather than wrapping database concepts in object-oriented abstractions. Built on the knex query builder, it lets developers write SQL-like queries programmatically while retaining access to the full power of the underlying database engine. It supports eager loading of relationships, graph inserts and upserts for complex object hierarchies, transactions, and optional JSON schema validation. The approach avoids the complexity of heavyweight ORMs by not attempting to hide SQL or automatically generate schemas from models.
Objection.js suits developers who are comfortable with SQL and want to leverage database-specific features without fighting an abstraction layer. It works well for projects using SQLite3, Postgres, or MySQL where the schema is managed separately through migrations. Choose this tool if you value explicit control over queries and want to avoid the conceptual overhead of fully object-oriented ORMs. The README explicitly contrasts itself with traditional ORMs like Hibernate, positioning itself as a lighter alternative that keeps SQL central rather than attempting to replace it with a custom query language.
The project maintains thorough test coverage across its supported databases. Development activity shows consistent engagement with the codebase and attention to the tool's core functionality. Official TypeScript support is provided through type definitions, indicating commitment to modern JavaScript ecosystem practices.
