SIFAR786

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$