Pranav Sathyanarayanan
06/02/2021, 7:42 PMqueryRaw in Prisma 2.23.0?
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:
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 queryRawPranav Sathyanarayanan
06/02/2021, 7:50 PMPrisma.join(Array.from(prodUserEmails))