ensure queries inside transaction have rollback capability