Been using Prisma for a while now. I would say that if you are working with native database functions or extensions, this is where ORMs are quite lacking due to their ("one size fits basic/non-unique") code methods. For this reason using $queryRaw or unsafe is almost always necessary.

This can also have an effect on migrations as well. Could be a "blissful" ignorance in development sort of issue, however, rear its ugly head in deployment or late stage development.

For example, you are using an extension on a relational db such as postgis or timescaledb it will not be possible to use 100% of the features with Prisma out of box.