I am using Data Pump to refresh (update + insert) a (pre-existing) data table with fresh data from an external source. The destination table includes "LastUpdate" column, which I would like to populate with the SQL Expression SYSDATETIMEOFFSET() for update statements (but leave as undefined or DEFAULT for INSERT statements.
This is a particular use case - but I can see this being generally very useful for manipulating incoming data for the destination.