Opening objects in separate views without closing them:
Option 1: Set this in:
Tools > Preferences > Database > ObjectViewer > Automatically Freeze Object Viewer Windows
Option 2: If you like to pin only certain query results and not all the time, here is an alternative: Option 1: Set this in:
Tools > Preferences > Database > ObjectViewer > Automatically Freeze Object Viewer Windows