Prisma allows you to create Data migrations easily by generating SQL, that you can deploy to your database. For most of the time, it will be fine to use out of the box, but sometimes you will have to make some changes to SQL.
There are a few ways to do it, one that is considered unsafe to use in production and that is push script, and the other one that definitely should be used in production and that is migrate and deploy.