[BUG] Saving multiple queries from the log explorer overwrites the previous query

[Swiddis]

What is the bug? When saving a query in log explorer, no new queries can be saved until the session is reset.

How can one reproduce the bug? Steps to reproduce the behavior:

1. Add an S3 data source
2. Go to Log Explorer
3. Create a saved SQL query with a given name
4. Go to dashboards management and observe the observability-search corresponding to your query in the saved object list
5. Change the query and save it with a new name
6. Observe that the old object has been overwritten

What is the expected behavior? On its own it's not that weird that the query is overwritten, but this persists when deliberately trying to make a new query: if you leave the log explorer, return to it, and start a new query (as opposed to opening the existing one), it still overwrites the last query. If you try to change the URL path away from the previous object and refresh the page, it still happens. I've found three ways to escape and generate a new query:

• Switch to a second S3 data source and then switch back.
• Log out and log back in.
• Open a new browser tab.

All three of these are unideal. I think the ideal solution would be a checkbox/slider that lets you pick whether to override or create a new query with an indicator of what the previous query is, or at least more intuitive way to start a new query editing session.

What is your host/environment?

• OS: Mac
• Version 2.13
• Observability Dashboards & co., OpenSearch Spark & co.

Do you have any screenshots? N/A

Do you have any additional context? N/A

[SohaibKatariwala]

This same issue applies to saving visualizations in Event explorer as well.