Hey guys, need some help writing a query in one transaction. I could create this in 2 separate transactions, but can't use the $transaction API as I need the ID of the first query, so trying to figure out how its done in one. See below for a high level example, where treatment_city is a joiner table for the two entities, city and treatment - when I insert a treatment, I want to insert the treatment ID and one other field into the joiner table along with the cityIds passed through to the API

await prisma.treatment.create({
	data: {
		name: "Treatment A",
		clinic: { connect: { id: "SOME ID" }},
		metadata: { create: { infos: "JSON" }},
		treatment_city: {
			createMany: {
				data: cityIds.map(cityId => ({
					city_id: cityId,
					metadata_id: <Id from above>, (??)
					treatment_id: <id of created treatment>, (??)
				}))
			}
		}
	}
})

you can try using the interactiveTransaction feature. It is currently in preview but we are using it in production and it is quite stable

Thanks @Dominic Hadfield - but I now get "promises is not iterable" when using Interactive Transaction

You don't need to await the last query and should return it

I did try that also with the same result