add preferences.during_trans and window auto statement