Can Wappler handle MSSQL store procedures and how about advanced queries?

How did you solve the problem with transaction control? For example, when adding an order with several items and there is a problem when adding one of the items and you need to undo the entire transaction? This is quite common in administrative systems! How did you solve? Or did you not handle these cases? Thank you friend!