Decode SendGrid Event ID in Postgres

sendgrid_eid.sql

create or replace function sendgrid_eid24_to_uuid(eid text)
returns uuid language sql immutable strict parallel safe
as $function$
    select encode(decode(translate(eid, '-_', '+/'), 'base64'), 'hex')::uuid;
$function$;


create or replace function sendgrid_eid48_to_uuid(eid text)
returns uuid language sql immutable strict parallel safe
as $function$
    select convert_from(decode(translate(eid, '-_', '+/'), 'base64'), 'UTF-8')::uuid;
$function$;


create or replace function sendgrid_eid_to_uuid(eid text)
returns uuid language plpgsql immutable strict parallel safe
as $function$
begin
    case octet_length(eid)
    when 22 then
        return sendgrid_eid24_to_uuid(eid || '==');
    when 24 then
        return sendgrid_eid24_to_uuid(eid);
    when 48 then
        return sendgrid_eid48_to_uuid(eid);
    else
        raise exception 'Unsupported event id: %', eid;
    end case;
end;
$function$;