prisma appears to have a transaction problem. https://github.com/prisma/prisma/discussions/12715
Perhaps they mean “Next generation” as in, the 1987 TV series sense. Which would still be a long time after the concept of joins…
to be clear, dont' use views in production queries. you WILL regret it.
source: made this mistake.