How about nested loops? whats the best way to write them?

If your requirements are covered by Prisma’s nested relations then that is the best way to go. Else you would need to use loops if your data is dependent on the previous result.

We need loops also because we are creating about 5 records for each table