koa-boilerplate VS Objection.js

With typeorm I can't do even basic things without query builder, and it's query builder is very verbose. For example, (this is not my code, just example): https://github.com/eflem00/koa-boilerplate/blob/98265346877a30f3595baf6f574726078b2b6c54/src/controllers/ArticleController.ts - I have very similar code on current project, have to use query builder, define return types manually, awfully not readable

Just thought I'd post my implementation of a RealWorld example app since it finally got put on their list. https://github.com/eflem00/koa-boilerplate It is a boilerplate configuration of Koa, TypeScript and TypeORM among other things to build a rest api that conforms to the RealWorld specs. It has many cool features, from being dockerized, implementing jwt auth and user credential encryption, to having a real integration test and CI/CD configuration.

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.