Added a in-transaction method which takes a list of statements and commits them in a batch in a transaction. If the transaction is successful, it will return the results. else it will be rolled back.