[ES|QL] Support row and ts in from e where in subqueries

[ES|QL] Support row and ts in from e where in subqueries #219477