normalized_and_casefold_NFKD_in_bigquery ref https://cloud.google.com/bigquery/docs/reference/standard-sql/functions-and-operators#normalize_and_casefold

normalized_and_casefold_NFKD_in_bigquery.sql

with subset as (
    select '１２３−４５６７' as x union all     -- 123−4567
    select '㌶' as x union all                -- ヘクタール
    select '㈱㈲' as x union all              -- (株)(有)
    select 'ｱｲｳｴｵＡＢＣａｂｃ①' as x union all -- アイウエオabcabc1
    select '〒〠〶' as x union all            -- 〒〠〒
    select '()（）' as x union all            -- ()()
    select 'ABCabc'
)
select x,
       NORMALIZE_AND_CASEFOLD(x, NFC) as fixed_x_NFC,
       NORMALIZE_AND_CASEFOLD(x, NFKC) as fixed_x_NFKC,
       NORMALIZE_AND_CASEFOLD(x, NFD) as fixed_x_NFD,
       NORMALIZE_AND_CASEFOLD(x, NFKD) as fixed_x_NFKD,
       NORMALIZE(x, NFKD) as fixed_x_NFKD_without_casefold,
from subset

行	x	fixed_x_NFC	fixed_x_NFKC	fixed_x_NFD	fixed_x_NFKD	fixed_x_NFKD_without_casefold
1	１２３−４５６７	１２３−４５６７	123−4567	１２３−４５６７	123−4567	123−4567
2	㌶	㌶	ヘクタール	㌶	ヘクタール	ヘクタール
3	㈱㈲	㈱㈲	(株)(有)	㈱㈲	(株)(有)	(株)(有)
4	ｱｲｳｴｵＡＢＣａｂｃ①	ｱｲｳｴｵａｂｃａｂｃ①	アイウエオabcabc1	ｱｲｳｴｵａｂｃａｂｃ①	アイウエオabcabc1	アイウエオABCabc1
5	〒〠〶	〒〠〶	〒〠〒	〒〠〶	〒〠〒	〒〠〒
6	()（）	()（）	()()	()（）	()()	()()
7	ABCabc	abcabc	abcabc	abcabc	abcabc	ABCabc