Hmm, was there some breaking change to how templat...
# orm-help
p
Hmm, was there some breaking change to how template strings are implemented for
queryRaw
in Prisma 2.23.0?
Copy code
await prisma.$queryRaw(`
    SELECT c."uuid", c."createdAt"
    FROM "EmploymentRecord" AS er
    JOIN "User" AS u ON (u."uuid" = er."userUuid")
    JOIN "Company" AS c ON (c."uuid" = er."companyUuid")
    WHERE er."endDate" IS NULL
    AND LOWER(u."email") IN (${Array.from(prodUserEmails)
      .map((email) => `'${email}'`)
      .join(', ')})
    GROUP BY c."uuid", c."createdAt"
    ORDER BY c."createdAt" ASC;
  `);
The query above works perfectly and returns my several hundred rows, but:
Copy code
await prisma.$queryRaw`
    SELECT c."uuid", c."createdAt"
    FROM "EmploymentRecord" AS er
    JOIN "User" AS u ON (u."uuid" = er."userUuid")
    JOIN "Company" AS c ON (c."uuid" = er."companyUuid")
    WHERE er."endDate" IS NULL
    AND LOWER(u."email") IN (${Array.from(prodUserEmails)
      .map((email) => `'${email}'`)
      .join(', ')})
    GROUP BY c."uuid", c."createdAt"
    ORDER BY c."createdAt" ASC;
  `;
Does not. I know I am manually string quoting my values, but not sure how else to perform an
IN
with
queryRaw
Ah I see, I have to use
Prisma.join(Array.from(prodUserEmails))
✅ 1