Add database snapshot and restore functionality with foreign key preservation

[gustavobtflores]

Implement a command to dump and load database snapshots while preserving relationships on foreign tables. This replaces the previous direct DB-to-DB migration flow and enables safer data migration and backup workflows.