SELECT json_agg()

in database-bridge-lambda/src/sql/User.ts [23:29]

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

        SELECT json_agg("email")
        FROM "User", "GroupMember"
        WHERE "shorthand" = "GroupMember"."groupShorthand"
        AND "GroupMember"."userGoogleID" = "User"."googleID"
        ), '[]') AS "memberEmails"
    FROM "Group"
    WHERE "shorthand" ILIKE ${"%" + args.prefix + "%"}