joist-orm VS Objection.js

As few comments have already offered alternatives, so I'll mention Joist.

I used TypeORM in the past; I had a ton of problems with it. I highly recommend https://joist-orm.io/ instead.

Codegen our backend models directly from the db (here a strict 1-1 mapping is a feature imo; we use https://github.com/stephenh/joist-ts/), so we get `Green` added to the backend `Color.ts` for free.

If you like Rails/ActiveRecord, Joist is our attempt at a "AR-or-better productivity" ORM for TypeScript.

Ha, well, as you noted, I'm wary of even bothering to comment :-), but would be great if you checked out Joist: https://joist-orm.io/

Checkout https://github.com/stephenh/joist-ts built from the ground up to be typesafe.

Objection.js is a SQL-friendly ORM for Node.js that supports various relational databases, including PostgreSQL, MySQL, and SQLite. It provides a flexible and expressive query builder. Objection.js is known for its expressive syntax, allowing developers to build complex queries easily. It supports eager loading, transactions, and migrations.

I don't think there's a best per say, but we did recently use Objection on our project. Did the job well, only issue is there's no constructor for the DB Models but it's just something you work around (https://vincit.github.io/objection.js/)

If you aren't using TypeScript I'd very much recommend Objection.js, I've used it multiple times and no complaints so far. You can pass raw SQL queries to it as well so I'm sure it would be a good fit for your project!

I'd also like to point out objection js is no longer actively maintained. I'm going to switch my work's codebase from it eventually because of it.

You should look into Objection.js. IMHO using that will make your life much easier as it seems you are trying to reimplement it's features in this sample code.

Next, let’s set up the database for our newly created Nest application. I’ll be using PostgreSQL, but you can use any of the databases Knex supports. To interact with our database, we’ll be using Objection.js, which is an ORM for Node.js built on top Knex. For this tutorial, we’ll be using Nest Objection, a Nest module for Objection.