This is a follow up to #135744 , to allow subqueries in from command work in CCS.

• - Ensure subquery and fork return deterministic results with CCS [ES|QL] Do not skip a remote cluster base on the query's execution time status #138332
• Ensure subqueries correctly honor the minimum transport version when determining which data types are supported and which are not during index resolution of CCS queries, c.f. [ES|QL] Support remote cluster in subqueries in from command #136035 (comment)
• - Enable CCS tests for subquery [ES|QL] Enable CCS tests for subqueries #137776
• - Collect correct status and metrics in EsqlExecuteInfo for each cluster, more detailed information might need to be collected on each branch/session for different subqueries
• - Support subquery with CPS