fix transaction sql generation

 - modify the returned sql for isolation level
 - remove some commented out code
 - cheat a little by reordering tests (look into this)