[ES|QL] Support failure store in ES|QL FROM

[ghudgins]

Describe the feature:

elastic/elasticsearch#118614

Access failure store in ES|QL

Describe a specific use case for the feature:

When I want to access failure store data for my query
I need to use FROM logs-*::failures*
So I can build an error dashboard and better understand the data that's failing

Update: The ES PR got merged. The grammar got updated here #216415. We need:

• support the :: in the client side validation
• add the :: in the ast parsing (which will fix the client side validation logic)
• add it in the autocomplete

[elasticmachine]

Pinging @elastic/kibana-esql (Team:ESQL)

[stratoula]

We are aware of this. The issue is blocked. We can't work on this without being merged in ES (_query api). There is not a lot of work (at least for this team). Only the autocomplete. Also no tech challenges

[gbamparop]

@stratoula is this unblocked now that elastic/elasticsearch#118614 is merged?

[stratoula]

I dont think that they have added that in ES|QL tbh, so I think is still blocked (I have asked the ES team too but they havent responded yet)

[stratoula]

ES replied, they are not aware of it.

[yngrdyn]

I think @jbaiera is working on enable this from es side. Maybe we can link the PR to track it down Here is the PR