Find customer usernames for a specific company example for "Prisma vs. TypeORM"

findConsumersForCompany.ts

export const findCustomerUsernamesForCompany = async (prisma: PrismaClient) => {
  return prisma.customer.findMany({
    select: {
      username: true,
    },
    orderBy: {
      username: 'desc',
    },
    where: {
      products: {
        some: {
          company: { name: 'Acme' },
        },
      },
    },
  });
};