Some tests for dialect ignores lack of support of CHECK CONSTRAINT

Describe the bug

Faced during the development of a new Dialect https://github.com/caretdev/sqlalchemy-iris/

for instance sqlalchemy/testing/suite/test_reflection.py - QuotedNameArgumentTest
Uses CheckConstraint unconditionally

To Reproduce

@property
    def check_constraint_reflection(self):
        """target dialect supports reflection of check constraints"""
        return exclusions.closed()

    def visit_check_constraint(self, constraint, **kw):
        raise exc.CompileError("Check CONSTRAINT is not supported")

### Error

Check CONSTRAINT is not supported

### Versions

- OS:
- Python:
- SQLAlchemy:
- Database:
- DBAPI `intersystems-iris`

https://pypi.org/project/sqlalchemy-iris/


### Additional context

_No response_

Start in sqlalchemy/testing/suite/test_reflection.py at QuotedNameArgumentTest and review how the check_constraint_reflection exclusion is defined and used. Run the affected reflection tests with a dialect that raises the shown CompileError; done means tests that require CHECK CONSTRAINT support are skipped or gated appropriately for unsupported dialects.