SELECT json_agg()

in email-lambda/src/index.ts [30:35]

• 6 lines of code
• 1 McCabe index (conditional complexity)

          SELECT json_agg("primaryEmail")
          FROM "Group"
          WHERE "Group"."shorthand" = ANY("Item"."groupMentions")
      ) AS "groupMentionEmails"
      FROM "Item" LEFT JOIN "User" ON "Item"."userEmail" = "User"."email"
      WHERE "id" = ${itemId}