Help migrating raw query from prisma to drizzle

  const results: any = await prisma.$queryRaw`
    SELECT COUNT(*) OVER()::integer AS count, 
             u.id as "userId",
       u."name", 
       u."plan",
       s.id AS "serviceId", 
       s."createdAt", 
       s."updatedAt", 
       s."name", 
       s."proposals" AS "serviceProposals",
       s."ack", 
       d."type",
             d."data"
    FROM "User" u
    LEFT JOIN "Directive" d ON u."userId" = d."id"
    LEFT JOIN "Service" s ON d."serviceId" = s."id"
    WHERE s."ack" = false
    AND u."plan" IN (${Prisma.join(plans)})
        ORDER BY s."createdAt" ASC
    LIMIT ${take} OFFSET ${skip}
  `;

  const results: any = await prisma.$queryRaw`
    SELECT COUNT(*) OVER()::integer AS count, 
             u.id as "userId",
       u."name", 
       u."plan",
       s.id AS "serviceId", 
       s."createdAt", 
       s."updatedAt", 
       s."name", 
       s."proposals" AS "serviceProposals",
       s."ack", 
       d."type",
             d."data"
    FROM "User" u
    LEFT JOIN "Directive" d ON u."userId" = d."id"
    LEFT JOIN "Service" s ON d."serviceId" = s."id"
    WHERE s."ack" = false
    AND u."plan" IN (${Prisma.join(plans)})
        ORDER BY s."createdAt" ASC
    LIMIT ${take} OFFSET ${skip}
  `;