I think the solution here, in conjunction with HHH-9577, is to have the PostgreSQL dialect override the new Dialect#contributeTypes method to replace the UUID type default.