Prisma

if its enabled you should be able to see an executeRaw resolver listed in the docs of your server, like if you open playground

I was able to connect to my DB to see the schema, I found a thread saying how to turn on rawAccess on heroku(prisma cloud)

but I still don't see execute raw on my functions

Hey! Anyone knows why generated prisma `query` with `contain` don't search strings like: `Hype!`, whitch contains `!` or another special characters? And it's not register insensitive (

I am facing similar issue when having underscore in string to be searched. Did you manage to find work-around for this?

Sorry, but no. I think you can use raw sql queries.

I have a related problem and I'm trying to figure this out too. I can access it from the playground, but not prisma-client

lol I just want to see how many times users have tagged a post with a similar tag

yeah. I was expecting something like prisma.$raw() ,but instead I guess one must use prisma.$graphql() and pass it in that way, but yeah, if you can't see it in playground then something is up

I guess it comes from the schema it downloads?

for you, if you do this
```
mutation { 
   exec
}
```

You are definitely in the playground for your server, not the outward-facing api?

```
  "errors": [
    {
      "message": "Cannot query field 'executeRaw' on type 'Mutation'. (line 2, column 3):\n  executeRaw(query: \"SELECT * FROMdefault$default.\\\"User\\\"\")\n  ^",
      "locations": [
        {
```

I posted on the forums, hopefully someone on the prisma team can help

<https://www.prisma.io/forum/t/no-way-to-get-number-of-objects-that-share-the-same-string-as-a-property/6694>

I actually got execute raw to finally work

Hello, how do you aggregate data for charts from prisma? Do you use direct MySQL queries or did you somehow do aggregation directly with prisma client?

Is it possible to use nested queries with TypeScript and prisma-client-lib? Previously with prisma-binding, it was possible to pass the info variable to the binding, but the prisma-client-lib lacks this capability. This blog <https://medium.com/@lukehamilton/nested-relations-in-prisma-971e060a16ab> helps me so far, I only have to extract the fragment from the info parameter. Are there already solutions?

If somebody is interested, I solved this problem with this quickfix.

// This function constructs the user query from the info parameter.
// TODO(till): This is a quick fix, wait for the Prisma client to support nested queries on its own.
export function infoToUserQuery(info, current: string = ‘’): string {
  if (current === ‘’) {
    info = info.fieldNodes[0].selectionSet.selections;
  }
  current += ‘{ ‘;
  for (const selection of info) {
    current += selection.name.value + ’ ‘;
    if (selection.selectionSet) {
      current = infoToUserQuery(selection.selectionSet.selections, current);
    }
  }

  current += ‘}’;
  return current;
}

<@UCZMXEP3J> Thank you very much for this great solution.

There is a better way to do this using type resolvers.

See: <https://www.prisma.io/tutorials/a-guide-to-common-resolver-patterns-ct08/#scenario:-implementing-relations-with-prisma-client>

Having a weird issue. I have a mutation that works in development running locally but returns a 400 error against production server. The code is the same. I’m kinda stumped, does anyone have an idea of what could be happening?

what does your prod environment look like?

Hey I'm blocked on a project because I either need to do a group by on a field, either through prisma or with a raw query through prisma but there is like no docs on either...

I can't figure out how to get execute raw to work through a server created with prisma cloud and heroku

I added rawAccess:true to the heroku DB config variables but nothing happened even restarted the node

Bumping, anyone know how to set up rawsql access on heroku with prisma cloud