DB Adapter - Batch Commit

To simultaneously perform inserts/updates on multipul tables, can I use a ‘Custom SQL Operation’ of the DB Adapter? If yes, how do I attain transactionality in this case? (full commit or full rollback)
I am not able to use the ‘Insert Operation’ of the DB Adapter since it supports only single table inserts/updates.
Thanks. in advance for help.