Displaying/Keeping previous Query Results VS Code

Question

Is there a way to keep previous query results when running new scrips?

Whenever I run a new script in the same window the new results overwrite the old ones, but ideally I'd like to keep the old ones and a new tab would open with the recent output.

I'm making a switch from SQL Developer to VS Code, where I was previously able to have multiple results kept, when re-running a script (see pic2)

I tried the SQL developer extension for VS Code and MySQL, amongst browsing all the settings. Unfortunately, I cannot find the right setting for what I need.

Answer 1

You can do this via a SQL Notebook.

Right-click on a connection.

Create your query, run it.

Add another code block, repeat...