### Description

Something like `select * from apps where version > '1.2.3'::version` fails with:
```
Caused by: java.lang.IllegalArgumentException: Illegal value type: class org.elasticsearch.xpack.versionfield.Version, value: 1.2.3
	at org.elasticsearch.xpack.versionfield.VersionStringFieldMapper$VersionStringFieldType.indexedValueForSearch(VersionStringFieldMapper.java:287)
	at org.elasticsearch.xpack.versionfield.VersionStringFieldMapper$VersionStringFieldType.rangeQuery(VersionStringFieldMapper.java:320)
	at org.elasticsearch.server@8.9.0-SNAPSHOT/org.elasticsearch.index.mapper.SimpleMappedFieldType.rangeQuery(SimpleMappedFieldType.java:52)
	at org.elasticsearch.server@8.9.0-SNAPSHOT/org.elasticsearch.index.query.RangeQueryBuilder.doToQuery(RangeQueryBuilder.java:539)
	at org.elasticsearch.server@8.9.0-SNAPSHOT/org.elasticsearch.index.query.AbstractQueryBuilder.toQuery(AbstractQueryBuilder.java:115)
	at org.elasticsearch.server@8.9.0-SNAPSHOT/org.elasticsearch.index.query.SearchExecutionContext.lambda$toQuery$4(SearchExecutionContext.java:486)
	at org.elasticsearch.server@8.9.0-SNAPSHOT/org.elasticsearch.index.query.SearchExecutionContext.toQuery(SearchExecutionContext.java:498)
	... 15 more


```
x-pack/plugin/ql/src/main/java/org/elasticsearch/xpack/ql/planner/ExpressionTranslators.java
if (lower instanceof ZonedDateTime || upper instanceof ZonedDateTime) {
                formatter = DateFormatter.forPattern(DATE_FORMAT);
            } else if (lower instanceof OffsetTime || upper instanceof OffsetTime) {
                formatter = DateFormatter.forPattern(TIME_FORMAT);
            }
            if (formatter != null) {
                
                
                
                if (lower instanceof ZonedDateTime || lower instanceof OffsetTime) {
                    lower = formatter.format((TemporalAccessor) lower);
                }
                if (upper instanceof ZonedDateTime || upper instanceof OffsetTime) {
                    upper = formatter.format((TemporalAccessor) upper);
                }
                format = formatter.pattern();
            }
            return new RangeQuery(
                r.source(),
                handler.nameOf(r.value()),
                lower,
                r.includeLower(),
                upper,
                r.includeUpper(),
                format,
                r.zoneId()
            );
        }
    }
    public static class InComparisons extends ExpressionTranslator<In> {