title: How to order by field called "count" in Prisma?
body: <p>I'm having hard times to find out how to order by <code>count</code> field in Prisma.</p>
  <p>The query looks like this:</p>
  <pre class="lang-js prettyprint-override"><code>const where = // ...
  const limit = // ...
  const skip = // ...
  const data = await this.prisma.translation.findMany({
        where,
        take: limit,
        skip: offset,
        orderBy: {
          count: 'asc'
          // ^ here is the issue, because count seems to be reserved for aggregations
        }
      });
  </code></pre>
  <p>Prisma model:</p>
  <pre><code>model Translation {
    id           String
    count        Int      @default(0)
  }
  </code></pre>
  <p>I found the docs here <a href="https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#orderby" rel="nofollow noreferrer">https://www.prisma.io/docs/reference/api-reference/prisma-client-reference#orderby</a> but it does not say anything how to say to prisma that the count does not mean aggregation but a column name.</p>
  <p>The error I'm getting:</p>
  <pre><code>Invalid `prisma.translation.findMany()` invocation:\n\n\n  Failed to validate the query: `Assertion error: Attempted conversion of non-map ParsedInputValue (Single(String(\&quot;asc\&quot;))) into map failed..` at ``
  </code></pre>
  <p>PS. I found this issue on GitHub that is still open <a href="https://github.com/prisma/prisma/issues/7806" rel="nofollow noreferrer">https://github.com/prisma/prisma/issues/7806</a>, gonna ask also there for some workaround or something...</p>
  <p>Thanks for any help :-)</p>