ES|QL MATCH roadmap

[carlosdelest]

Tracked in #123043
This meta issue tracks the progress on MATCH features for ES|QL.

In progress

• ES|QL - Allow full text functions to be used in STATS ... WHERE #125481

Backlog - Before GA

Backlog - Post GA

• ES|QL - Remove LIMIT limitation for full text functions #127415
• Add fuzziness for match operator
• Add boosting for match function and operator (prerequirement: ESQL - enabling scoring with METADATA _score #113120)
• Remove limitation of using full text functions after LIMIT #115297
• EVAL between match functions with scoring enabled
• Allow match after STATS .. BY when push down filters past stats is allowed (ESQL: push down filters past STATS #115311)
• ES|QL: Add support for match_phrase #125012
• ES|QL - Allow full text functions to be used in EVAL #125482

Done

• Add ESQL match function #113374
• Add ES|QL match operator (:)  #114831
• ESQL: MATCH following MV_EXPAND will produce an invalid plan #115353
• ESQL - match operator included in non-snapshot builds #116819
• Improve type compatibility for match - Add boolean, number, date, IP...-
  • ESQL: Expand type compatibility for match function and operator  #117555
• ESQL - Remove restrictions for disjunctions in full text functions #118544
• Avoid failing on indices that don't have the field (when querying multiple indices) - This was checked and works correctly
• Allow additional options for match function
• Allow disjunctions to work for match function and operator
  • [Design doc](https://docs.google.com/document/d/1g6ocs-T03cm5RRqwW7s1mHEV1lRoZWhrWrM54XvLKtk/edit?
  • ESQL - Allow full text functions disjunctions for non-full text functions #120291
  • ES|QL - Add scoring for full text functions disjunctions #121793
• ES\QL: Fix scoring for non full text functions #124540
• ES|QL Full Text Functions benchmarking #124649
  • Stress test for full text functions - Benchmarking done in this doc

[elasticsearchmachine]

Pinging @elastic/es-search-relevance (Team:Search Relevance)

[elasticsearchmachine]

Pinging @elastic/kibana-esql (ES|QL-ui)