In 4.0, this behavuiour change persists.
Any idea how I get my previous default of append back?
It's a pain when I'm editing a sheet of multiple SQL statements.
The change was intentional. If you're frequently using sql from the history, you quickly get a cluttered worksheet.
If you prefer the append behavior, try the keyboard shortcut, ctrl+shift+up/dn