How to translate this query to prisma?

SELECT id, name from posts where id IN (select post_id from comments where user_id='123');

One approach would be to do the inner select first. Await the results. And then loop through them and do The outer select on each entry you got back.

@Omar Hamdan That's really a costly approach :/

@Vignesh 👋 Assuming this is your schema:

model User {
  id       Int       @id @default(autoincrement())
  name     String
  posts    Post[]
  comments Comment[]
}

model Post {
  id       Int       @id @default(autoincrement())
  title    String
  comments Comment[]
  user     User?     @relation(fields: [userId], references: [id])
  userId   Int?
}

model Comment {
  id      Int    @id @default(autoincrement())
  comment String
  author  User?  @relation(fields: [userId], references: [id])
  post    Post?  @relation(fields: [postId], references: [id])
  postId  Int?
  userId  Int?
}

It could be done as follows:

await prisma.comment.findMany({
    where: { userId: 123 },
    include: { post: true },
  })

@Ryan Thanks for the reply.. But It'll return comments data which i don't want.. Is there a way to unselect all fields of comment instead of explicitly mentioning false to each field?

You can use

select

then instead of

include

and specify the required fields.