[BUG] Validate session with flint datasource passed in async job request

[ps48]

What is the bug?
Currently, if there's a session running with Datasource1 and user makes a request to the async API with same session but a different catalog Datasource2 then SQL plguin doesn't return a new session for Datasource2.

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

1. Query Datasource1 to create a new session.
2. Query Datasource2 with same session.
3. Check the response in session from step 2.

What is the expected behavior?
Whenever session is passed as part of async API, SQL plugin should check if the session datasource matches the request datasource. If datasource doesn't match then sql plugin should return the correct/new session in response.

What is your host/environment?

• OS: AL2
• Version 2.11
• Plugins: SQL

Do you have any screenshots?
If applicable, add screenshots to help explain your problem.

Do you have any additional context?
Related to UI passing wrong sessions: opensearch-project/dashboards-query-workbench#216