> Also, it's worth mentioning that some objects like domains and roles require special handling since there is no built-in "IF NOT EXISTS" escape hatch for these constructs.

Great point. A post on how to write PostgreSQL DDL for objects that don't support idempotence would be helpful. If I recall, you had written some SQL to enable better support for idempotent PostgreSQL DDL.