[ES|QL] Sorting accepts expressions

[drewdaemon]

Summary

SORT accepts expressions as of https://github.com/elastic/elasticsearch/pull/107158.

This PR updates the validator and autocompletion engine to account for this improvement.

Checklist

• [ ] Documentation was added — looks like docs haven't been added for this feature yet. I opened the discussion with ES team (ref)
• [x] Unit or functional tests were updated or added to match the most common scenarios

[drewdaemon]

/ci

[drewdaemon]

/ci

[elasticmachine]

Pinging @elastic/kibana-esql (Team:ESQL)

[drewdaemon]

@elasticmachine merge upstream

[kibana-ci]

:green_heart: Build Succeeded

• Buildkite Build
• Commit: bdead553f8e365d6b643ccc7f01ccbcdf4c13be5

Metrics [docs]

Page load bundle

Size of the bundles that are downloaded on every page load. Target size is below 100kb

id	before	after	diff
kbnUiSharedDeps-srcJs	3.1MB	3.1MB	+98.0B

History

• :yellow_heart: Build #206509 was flaky 487ec03cfca9a9311d9fa2abd2f4153e0f34690e
• :green_heart: Build #206458 succeeded eb965c97a774fe4048d05666059a9873e3ce88a2

To update your PR or re-run it, just comment with: @elasticmachine merge upstream

[kibanamachine]

💚 All backports created successfully

Status	Branch	Result
✅	8.14

Note: Successful backport PRs will be merged automatically after passing CI.

Questions ?

Please refer to the Backport tool documentation