Prisma

Hey everyone :wave:, been exploring Prisma and I’m curious if there is a way for me to annotate a new field with Prisma READ:

For example, if we have a simple Post, User, &amp; Like table:

```// prisma.schema
Table Post { likes [], ... }

Table User { likes [], ... }

Table Like { userId, postId, ...}```
Is there a way for me to create a new `likedByUser`  Boolean field (Not part of the Post Schema) like this:
```prisma.post.findMany({
  where: {..}
  select: {
    likedByUser: { // New annotated field
       where: { 
         likes: [
           { userId: { equals: 2 } },
         ]
       }
    }
  }
});```

For more context, I’m trying to optimize for performance. An alternative is to loop through each Post and fire a single query which can be slow.

```// 1 query
posts = await prisma.post.findMany(..);

// n queries
forEach post:
  const likedByUser = await prisma.like.findFirst({ where: post: post.id, userId: 2 });```

You cannot create annotated/virtual fields not part of the schema as of now.
Have a look at this <https://github.com/prisma/prisma/issues/3394|request> and it would be great if you could add a :thumbsup: so that we know the priority for this :slightly_smiling_face:

Gotcha, thanks for pointing me there Ryan :slightly_smiling_face: