Cleaning or validating emails and telephones numbers with RegEx with SQL in Presto DB. (Portuguese Version)

regex_cleaning_email_and_telephone_prestodb.sql

SELECT *,
CASE
  WHEN e.email like '%_@_%_.__%'
      AND NOT regexp_like(coalesce(trim(regexp_extract(e.email, '.+?(?=@)')), '$'),
                          '[^a-zA-Z0-9\._-\ã\õ\ẽ\é\ó\ú]')
    THEN lower(e.email)
  ELSE 'N/A'
END
) AS email,
CASE
  WHEN regexp_like(regexp_replace(e.telephone, '[^0-9]'), '^[0-9]')
        AND length(regexp_replace(e.telephone, '[^0-9]')) > 7
        AND NOT regexp_like(regexp_replace(e.telephone, '[^0-9]'), '\b(\d)\1+\b')
    THEN regexp_replace(e.telephone, '[^0-9]')
  ELSE 'N/A'
END
) AS telephone,
FROM database.table as e