### Description

This works:
```
POST _query
{
  "query": "from kibana_sample_data_logs | limit 10000",
  "filter": {
    "range": {
      "@timestamp": {
        "format": "strict_date_optional_time",
        "gte": "2023-12-12T13:00:00.000Z",
        "lt": "2023-12-12T14:00:00.000Z"
      }
    }
  }
}
```

But this returns empty values array:
```
POST _query
{
  "query": "from kibana_sample_data_logs | limit 10000",
  "filter": {
    "range": {
      "@timestamp": {
        "format": "strict_date_optional_time",
        "gte": "2023-12-12T13:00:00.000Z",
        "lt": "now"
      }
    }
  }
}
```
x-pack/plugin/esql/src/main/java/org/elasticsearch/xpack/esql/plugin/ComputeService.java
for (SearchShardsGroup group : resp.getGroups()) {
                    var shardId = group.shardId();
                    if (group.skipped()) {
                        continue;
                    }
                    if (group.allocatedNodes().isEmpty()) {
                        throw new ShardNotFoundException(group.shardId(), "no shard copies found {}", group.shardId());
                    }
                    if (concreteIndices.contains(shardId.getIndexName()) == false) {
                        continue;
                    }
                    String targetNode = group.allocatedNodes().get(0);
                    nodeToShards.computeIfAbsent(targetNode, k -> new ArrayList<>()).add(shardId);
                    AliasFilter aliasFilter = resp.getAliasFilters().get(shardId.getIndex().getUUID());
                    if (aliasFilter != null) {
                        nodeToAliasFilters.computeIfAbsent(targetNode, k -> new HashMap<>()).put(shardId.getIndex(), aliasFilter);
                    }
                }
                List<TargetNode> targetNodes = new ArrayList<>(nodeToShards.size());
                for (Map.Entry<String, List<ShardId>> e : nodeToShards.entrySet()) {
                    DiscoveryNode node = nodes.get(e.getKey());
                    Map<Index, AliasFilter> aliasFilters = nodeToAliasFilters.getOrDefault(e.getKey(), Map.of());
                    targetNodes.add(new TargetNode(node, e.getValue(), aliasFilters));
                }
                return targetNodes;
            }),
            threadContext
        );
        try (ThreadContext.StoredContext ignored = threadContext.newStoredContextPreservingResponseHeaders()) {
            threadContext.markAsSystemContext();