Check constraint migration fails with syntax error

ALTER TABLE "api_owner"
    ADD CONSTRAINT "check_owner_one_null" CHECK (user_id IS NOT NULL AND organization_id IS NULL) OR (user_id IS NULL AND organization_id IS NOT NULL);

ALTER TABLE "api_entity"
    ADD CONSTRAINT "check_non_self_parent" CHECK (parent_id <> id);

ALTER TABLE "api_owner"
    ADD CONSTRAINT "check_owner_one_null" CHECK (user_id IS NOT NULL AND organization_id IS NULL) OR (user_id IS NULL AND organization_id IS NOT NULL);

ALTER TABLE "api_entity"
    ADD CONSTRAINT "check_non_self_parent" CHECK (parent_id <> id);

Migration `20240404221624_check_constraints` failed to apply cleanly to the shadow database.
Error:
ERROR: syntax error at or near "OR"
   0: sql_schema_connector::validate_migrations
           with namespaces=None
             at schema-engine\connectors\sql-schema-connector\src\lib.rs:324
   1: schema_core::state::DevDiagnostic
             at schema-engine\core\src\state.rs:267

Migration `20240404221624_check_constraints` failed to apply cleanly to the shadow database.
Error:
ERROR: syntax error at or near "OR"
   0: sql_schema_connector::validate_migrations
           with namespaces=None
             at schema-engine\connectors\sql-schema-connector\src\lib.rs:324
   1: schema_core::state::DevDiagnostic
             at schema-engine\core\src\state.rs:267