Preview feature feedback: nativeDistinct

[janpio]

Support for the database native DISTINCT queries with our distinct API is in preview behind the nativeDistinct preview feature.

Please share your feedback about nativeDistinct released in v5.7.0 in this discussion.

• If you encounter a bug, please open a bug report in this repository.
• If the feature is working well for you, please share this in a comment below or leave a 👍 on this discussion.
• Need help or have questions? Join the Prisma Discord community and ask away! We're here to support you.

[meotimdihia]

Native DISTINCT doesn't work when we used orderBy

          await fastify.prisma.user_info.findMany({
            distinct: ["role"],

            select: {
              role: true
            },
            orderBy: {
              role: {
                sort: "desc",
                nulls: "last"
              }
            }
          })

or use take and limit

          await fastify.prisma.user_info.findMany({
            distinct: ["role"],
            take: req.query.limit,
            skip: req.query.page * req.query.limit,
            select: {
              role: true
            }
          })

I created the issue: #22734

It looks like we have to work around this problem by using subqueries: https://stackoverflow.com/questions/9795660/postgresql-distinct-on-with-different-order-by