Transactions with sqlserver

Hi Community,

Is there a possibility to have cross-snap transactions in snaplogic, where we manage the transactions manually (e.g. by manually issuing commit or rollback at the end of the transaction)?

for a usecase, we’d need to run multiple inserts into different tables in a SQL Server database in one transaction (if one of the queries fails, we’ll need to roll back all inserts).

it’ll need to be transaction-safe, as there is an application running on top of the tables which does similar inserts.
Obviously this could be done with the SQL execute snap - however that’d mean coding the whole SQL query manually (including potential SQLi escaping) - which we’d not really like to do, for hopefully obvious reasons.