if you need subscriptions, you should move to something like hasura, that was the advice my team got from a prisma engineer