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.