orms-overview VS KeystoneJS

Here is the post, u/BehindTheMath said "Raw SQL could be a viable option is there wasn't any JS logic and all the code was Knex." and I completely agree, and I can't even imagine how would you rewrite this knex code to raw sql.

Here is what I have written with Knex: https://github.com/romeerez/orms-overview/blob/master/src/orms/knex/article/article.repo.ts

And once ago I did something similar for postgres to wrap 'pg' library to patch queries with transactions, used it in real project and also in weekend project, here is source of patching

Keystone 6: The GraphQL Behemoth

Also, there are lots of exciting web frameworks that use Prisma as their default ORM layer (like RedwoodJS which is built by the founder of GitHub, Amplication which recently raised $6.6M in seed funding, Wasp (YC W21) or KeystoneJS) which should give you some more validation that Prisma is being used in a lot production applications :)

KeystoneJS https://keystonejs.com

https://keystonejs.com/ is a nice smaller alternative.

Keystone.js is a content management system and framework for creating server-side applications that interact with a database. It is based on the Express platform for Node.js and uses MongoDB for data storage. It is an alternative to CMS for web developers who want to create a data-driven website, but do not want to move to the PHP platform or too large systems such as WordPress.

I have a website I've built in nextjs frontend using keystonejs as a cms written in node.

I have a working graphql server written in Keystone CMS and hosted on Heroku.

Even you can use WordPress through their API, I would recommend you to try KeystoneJsKeystone Js CMS, as others suggested before, there are several headless CMSs but Keystone is totally free, open source and self hosted, you can even deploy on vercel. take a look

The most ok alternative would probably be something like Keystone.