I quite liked Prisma when I used it, I'm glad someone brought it up.
The issues with Prisma are that it had moderately weak support for Typescript, and doesn't robustly support related data querying (inc. recursively), or exotic inter-object relations (e.g. many-to-many with join tables, etc.).
As I said, a lot of the ORMs you find out there tend to be quite simple, missing some QoL features.
