Objection.js

Objection.js is an ORM for Node.js that aims to stay out of your way and make it as easy as possible to use the full power of SQL and the underlying database engine while still making the common stuff easy and enjoyable.

Even though ORM is the best commonly known acronym to describe objection, a more accurate description is to call it a relational query builder. You get all the benefits of an SQL query builder but also a powerful set of tools for working with relations.

Objection.js is built on an SQL query builder called knex. All databases supported by knex are supported by objection.js. SQLite3, Postgres and MySQL are thoroughly tested.

What objection.js gives you:

• An easy declarative way of defining models and relationships between them
• Simple and fun way to fetch, insert, update and delete objects using the full power of SQL
• Powerful mechanisms for eager loading, inserting and upserting object graphs
• Easy to use transactions
• Official TypeScript support
• Optional JSON schema validation
• A way to store complex documents as single rows