OptionalFOREIGN_Optional: PostgreSQL has no SET FOREIGN_KEY_CHECKS. The session-level
equivalent is session_replication_role, which is present on true
PostgreSQL and CockroachDB but absent from some PostgreSQL-derived engines
(Redshift does not enforce foreign keys at all), so this is deliberately
optional rather than a required member with a fake value.
PostgreSQL SQL constants