@Tubeshop Speaking of exiting entries in DB you could sanitize that with use of REGEXP_REPLACE(name, '\\s+', ' ', 1, 0) but if there are some names that'd lead to UNIQUE constraint violation you'd need to handle that too. For example like that (It's ugly but should work):
WITH normalizedMap AS (...