any recommendations on how to use prisma to backfill data? a typical scenario we have is that we add a column to a table. All the existing records need to be updated to add a value based on some logic. How can I use prisma to insert those values to the new column on existing records?

This is something you could do 1. Create and apply a migration of adding column without constraints 2. Backfill the database with the required data using Prisma Client 3. Create and apply new migration with necessary constraints