Unable to update Saved Queries

[yousoph]

Bug description

Description

Users can save queries from the SQL Lab for future reference or reusability. However, accessing the saved queries from the list creates a new saved query upon saving the changes rather than updating the existing saved query

How to reproduce the bug

1. Run a query in the SQL Lab.
2. Save the query.
3. Close the query tab.
4. Access the saved query from the SQL > Saved Queries menu.
5. Perform some changes and save.

Expected results

The query will have an update or save as new option. User should see a Save As modal that allows them to update their current query (see screenshots below)

Actual results

The query can only be saved as a new saved query.

Other Details

Query can be updated as long as the query tab is not closed. Any tabs that are opened later will show the incorrect modal without the Save as New / Update options.

Screenshots/recordings

What the user currently sees when trying to save a query:

Save modal should look like the below when editing your existing query:

Superset version

master / latest-dev

Python version

3.9

Node version

16

Browser

Chrome

Additional context

No response

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.

[peacelovingng]

When you try to save a new query initially, it displays the first screenshot. When you save and make changes, you see the second screenshot.

[DamianPendrak]

I'd like to work on this issue

[Niharika0104]

I'd like to work on this issue @geido

[geido]

I'd like to work on this issue @geido

This issue is already assigned for now

[syedbarimanjan]

@geido can I work on this issue as it has been more than 2 weeks and no response from the assigned contributer.