is it normal for prisma to execute 2 queries instead of a join in this case?

Hey Dennis 👋 Yes, Prisma internally uses select statements instead of joins. Here’s the thread which discusses this approach https://prisma.slack.com/archives/CA491RJH0/p1646982182446919?thread_ts=1646799638.123979&cid=CA491RJH0

Thanks @Nurul! Does Prisma by default wrap all queries in a transaction?

Hey Paul 👋 In case you are referring to queries like createMany, updateMany then yes they are wrapped in a transaction

Awesome thanks!