dolt_verify_constraints doesn't work for foreign keys

[zachmu]

select dolt_verify_constraints() does not work to check foreign keys because we are serializing or parsing some the constraint with the wrong dialect:

select dolt_verify_constraints();
ERROR:  error calculating constraint violations: at or near "credential_references_id_unique": syntax error