[ESQL] Version is a required field

[cauemarcondes]

On this PR the ESQL _query api was changed making the version property required.

Currently, if I call the esql query I got back this error message:

{
  name: 'ResponseError',
  message: 'action_request_validation_exception\n' +
    '\tRoot causes:\n' +
    '\t\taction_request_validation_exception: Validation Failed: 1: [version] is required, latest available version is [2024.04.01];'
}

How does the query look like now?

POST _query
{
  "query": """
  FROM my-index*
  """,
  "version": "2024.04.01"
}

We should change the src/api/api/esql.ts file to accept a version in the API.

[stratoula]

There are 2 ways to run the _query in kibana atm:

1. Use the async search strategy https://github.com/elastic/kibana/blob/main/src/plugins/data/server/search/strategies/esql_async_search/esql_async_search_strategy.ts. One example of the usage here
2. The other is using the es client like that

[JoshMock]

There's an open conversation about how to handle this in each client. I'm planning to resolve how to best handle this for the JS client very soon.

[JoshMock]

A default version is now injected if one is not provided. This fix has been merged to main and 8.14 branches, so it will be available when 8.14.0 ships.