Applies AshReferentialActions semantics to soft destroys implemented by AshArchival.

When restrict edges require a specific sequential cascade order, place only the exceptional tail in archive_last:

referential_actions do
  archive_last [:shared_assets]
end

This option belongs to the archival adapter because PostgreSQL executes physical referential actions itself and does not need application-level cascade ordering.