3 ms·

Generated columns (i.e. some_json->>'id') can have constraints just fine, maintaining whatever integrity you want