As suggested by Murta previously, BigQuery's TRANSLATE function is very handy and allows you to do exactly what you need to. https://cloud.google.com/bigquery/docs/reference/standard-sql/string_functions#translate
SELECT TRANSLATE('brasília', 'í', 'i') AS translated