SQL Lab Executes Only the Last Query When Multiple Queries Are Submitted Together

[jan21deepak]

Bug description

When multiple SQL queries are entered and executed together in SQL Lab, Superset only returns the result of the last query. The results from the preceding queries are not displayed.
When three queries are submitted together, only the result of the last query is displayed.

Screenshots/recordings

Can't share the exact image because it is our customer IDs.

Superset version

master / latest-dev

Python version

3.12

Node version

18 or greater

Browser

Chrome

Additional context

The issue is reproducible when executing three or more SQL statements in a single SQL Lab execution. It appears that only the final statement's result set is returned to the user while previous query results are not surfaced in the U

Checklist

• I have searched Superset docs and Slack and didn't find a solution to my problem.
• I have searched the GitHub issue tracker and didn't find a similar bug report.
• I have checked Superset's logs for errors and if I found a relevant Python stacktrace, I included it here as text in the "additional context" section.

---

Imported from the parent repository for autonomous engineering evaluation.

Source issue: apache#42998

[jan21deepak]

✅ Task completed

• Cursor agent ID: bc-4ae6ff8d-eced-4bd8-9d40-3d404c10f5b4
• Pull Request: SQL Lab Executes Only the Last Query When Multiple Queries Are Submitted Together (#71) #80
• Runtime: 5m 16s
• Completed at: 11 Aug 2026 13:28 SGT

Summary of changes:

Summary

Fixed issue #71 — SQL Lab only showing the last query result when multiple statements were executed together.

Root cause

In execute_sql_statements (superset/sql_lab.py), the execution loop overwrote result_set on each iteration and only the final result was serialized into the API payload.

Fix

1. Backend (sync path): Collect all statement results and build a statements array in the response, while keeping top-level data/columns from the last data-bearing statement for backward compatibility.
2. Backend (async path): Update Celery finalization and results-backend deserialization so multi-statement payloads deserialize correctly.
3. Frontend: Add statement tabs in ResultSet when multiple data-bearing statements are returned.

Tests run

• pytest tests/unit_tests/sql_lab_test.py::test_build_statements_payload_preserves_all_data_bearing_statements — passed
• pytest tests/unit_tests/sql/execution/test_celery_task.py — 47 passed
• npm run test -- src/SqlLab/components/ResultSet/ResultSet.test.tsx — 37 passed

Branch

cursor/fix-sqllab-multi-query-results-f5b4

Pushed to https://github.com/jan21deepak/superset. A PR draft was registered for your approval.