Introduce 'commit' option for transaction to control auto commit