[studio] Support multiple results in SQL Editor

[osaxma]

Feature request

Current limitation

Running multiple queries only shows the result of the first query:

Supabase SQL Editor

Describe the solution you'd like

I would like the SQL editor to show a result for each query such as:

SQL Notebook (VS Code extension)

Describe alternatives you've considered

Using other SQL editors than Supabase's.

Additional context

I mainly use the SQL Editor for debugging flow such as: set role authenticated, modify request.jwt to match user id and role, then execute query to see result.

Typically I'm interested in the result of the last query but I think supporting all results (within diff tabs or stacked) would be more beneficial.

[saltcod]

Hey @osaxma !

Very neat request. I'm going to move this into Discussions and flag it as a feature request. Great idea.