core: db transactions

Fabio Maschirequested to merge
feat/db-transactions into main

extracted from !431 (merged), so DB transactions are available to be used in !421 (merged)

Merge request reports