Prisma

Hi, Is there a way to convert an object into a prisma object

<@U01BV68959V> :wave:
Could you provide an example of that object if possible?

rather than using `findMany` to get a list of users from my db, i use some customSQL to get the data from that table i need, but i want the results to be in the same for as if it where using findMany

In this case, a `map` function that does just this conversion should work. And then you can use that in your logic to return in the same way.

Prisma unfortunately doesn’t have any inbuilt function to do this.

This type:
```import { Prisma } from '@prisma/client'

const map = (data): Prisma.UserGetPayload =&gt; {
  // return the data as per the return type
}```


Hmm im not sure that will do what Im after

im probably not doing a great job explaining

An example with sample data would be great!

```model User {
  id        Int      @id @default(autoincrement()) @map("user_id")
  email     String   @unique @map("user_email")
  posts     Post[]
}

model Post {
  id        Int      @id @default(autoincrement()) @map("post_id")
  title     String   @db.VarChar(255) @map("post_title")
  author    User?    @relation(fields: [authorId], references: [id])
  authorId  Int? @map("post_author_id")
}```

i could do `const users = await prisma.user.findMany()`

``` ctx.prisma.users
    .findUnique({
      where: { id: 1 },
    })
    .posts()```

i could also do this to get the posts of a specific user

```const myUser = ctx.prisma.$queryRaw(
      `SELECT * from customSearch(${userId})`,
    )
const myUserPrisma = someConvertFunction(myUser)

const posts = myUserPrisma.posts()```