ugh.sql

create
    definer = root@`%` procedure emailRecord_5_explain(IN inEmail varchar(255) CHARACTER SET utf8 COLLATE utf8_bin)
BEGIN
    SELECT
        a.uid,
        a.email,
        a.normalizedEmail,
        a.emailVerified,
        a.emailCode,
        a.kA,
        a.wrapWrapKb,
        a.verifierVersion,
        a.authSalt,
        a.verifierSetAt,
        a.lockedAt,
        a.createdAt,
        a.ecosystemAnonId
    FROM
        accounts a
    WHERE
        a.normalizedEmail = LOWER(inEmail)
    ;
END;