load: update sequences in one transaction/SQL command

[slint]

One thing to investigate in the future is the ability to do this with a single SQL statement (or in one transaction). I see some ideas that we can combine from this SO thread.

Originally posted by @slint in https://github.com/inveniosoftware/invenio-rdm-migrator/pull/54#pullrequestreview-1410301089

[ppanero]

https://wiki.postgresql.org/wiki/Transactional_DDL_in_PostgreSQL:_A_Competitive_Analysis

[ppanero]

I think this is not needed anymore since updates come now as part of the actions stream. re-open if we need to reconsider.