A general change in the logic of the Query Designer is that now we remember the view mode that was in use while the modification to design happened, not just the fact that the modification happened previously (since the last saving changes).
BUG:278379
Also fixes this:
Changes in query design not retained after changes in SQL view and switching to Data view
BUG:358413
FIXED-IN:2.9.11