[cjpb]

I've tried Prisma, TypeORM and MikroORM and I'm certainly the most impressed with MikroORM.

It's simple and the use of identity map within a unit of work, tied to a request context (for example), is just brilliant.

The handling of relations (with configurable loading strategies) and other features such as Embeddables and Filters make it a real joy to use.

And if at any point I can't achieve something with MikroORM itself (which generally in my case is calling a PostgreSQL function), I can easily grab the underlying Query Builder from Knex.

It also has the tooling to generate a schema from your Entities, or generate Entities from an existing schema - so it's easy to get started on something new or existing.