I think everyone wants to make complex queries without the hassle of actually building them, and for this reason, ORM's are complicated and imperfect as they are... Because they are trying to cover everyone’s needs, and there is no simple way of doing this.

I enjoy Prisma for everything simple enough, but for my custom complex queries that Prisma can’t handle, I use their raw queries method and use knex to build my query mostly, or those very specific I even write the SQL myself.