### Elasticsearch Version

8.11.0

### Installed Plugins

_No response_

### Java Version

_bundled_

### OS Version

MacOS

### Problem Description

I would expect a clear message for the following ES|QL query:

```
from index | where 1 year
```

But what I get is:

```
[esql] > Unexpected error from Elasticsearch: illegal_argument_exception - Unrecognized class type class java.time.Period
```

### Steps to Reproduce

See above.

### Logs (if relevant)

_No response_
x-pack/plugin/esql/src/main/java/org/elasticsearch/xpack/esql/analysis/Verifier.java
p.forEachExpression(e -> {
                
                if (e.resolved()) {
                    return;
                }
                e.forEachUp(ae -> {
                    
                    if (ae.childrenResolved() == false) {
                        return;
                    }
                    if (ae instanceof Unresolvable u) {
                        
                        if (p instanceof Project == false || u instanceof UnsupportedAttribute == false) {
                            failures.add(fail(ae, u.unresolvedMessage()));
                        }
                    }
                    if (ae.typeResolved().unresolved()) {
                        failures.add(fail(ae, ae.typeResolved().message()));
                    }
                });
            });
        });
        
        if (failures.isEmpty() == false) {
            return failures;
        }
        
        plan.forEachDown(p -> {
            if (p instanceof Aggregate agg) {
                agg.aggregates().forEach(e -> {