PostgreSQL

Restore with psql

psql -U admin -W -h localhost -d odoo_main -f dump.sql

Update with join

UPDATE account_move_line SET balance_second_currency = debit_second_currency - credit_second_currency FROM  account_move AS am WHERE move_id = am.id AND am.name = 'MANUAL/2022/10/0002'