CODE EXAMPLE FOR SQL

prisma transaction

const [posts, totalPosts] = await prisma.$transaction([
  prisma.post.findMany({ where: { title: { contains: 'prisma' } } }),  
  prisma.post.count(),
])