PostgreSQL check constraint reflection strips brackets naively #13157

from sqlalchemy import (
    CheckConstraint,
    Column,
    Integer,
    MetaData,
    Table,
    create_engine,
    inspect,
)
from sqlalchemy.schema import CreateTable


def main() -> None:
    engine = create_engine("postgresql:///issue13157")

    foo = Table(
        "foo",
        MetaData(),
        Column("id", Integer),
        Column("x", Integer),
        Column("y", Integer),
        CheckConstraint(
            "(x IS NULL OR y IS NULL) AND (x IS NULL OR y IS NULL)",
            name="broken",
        ),
    )

    with engine.connect() as conn:
        conn.execute(CreateTable(foo))
        inspector = inspect(conn)
        (broken,) = inspector.get_check_constraints(foo.name)
        print(broken["sqltext"])


if __name__ == "__main__":
    main()