Generated columns

From the collection Ecto and Postgresql

ALTER TABLE sanctions_lists
    ADD COLUMN soundex_code varchar
    GENERATED ALWAYS
    AS (
        CASE
            WHEN full_name is NULL THEN soundex('XXXXXXX')
            ELSE soundex(full_name)
        END
    ) STORED