Create nested entities

[alechko]

Problem

Currently it's not possible to create nested entities within a single operation, for example, consider a scenario of seeding a User with a Post and a Comment with children Comments (replies):

    await prisma.user.create({
      data: {
        email: faker.internet.email(),
        posts: {
          create: {
            title: faker.lorem.sentence(10),
            comments: {
              create: [
                {
                  body: faker.lorem.paragraph(10),
                  children: {
                    create: [ <--- THIS FAILS TO INHERIT THE POST
                      {
                        body: faker.lorem.paragraph(10),
                      }
                    ]
                  },
                },
              ],
            },
          },
        },
      },
    });

Comment model:

model Comment {
  id          String          @id() @default(uuid()) @db.Uuid
  body        String

  post        Post            @relation(fields: [postId], references: [id], onDelete: Cascade)
  postId      String          @db.Uuid

  parent      Comment?        @relation("CommentParent", fields: [parentId], references: [id])
  parentId    String?         @db.Uuid
  children    Comment[]       @relation("CommentParent")
}

Suggested solution

It could be helpful if nested create would inherit the parent entity fields/relations instead of manually creating and relating entities.

[ahsansher]

It will be a huge timesaver but still no discussion on it.