LAG() LEAD() Functions in ES|QL

YousefNein (Yossif Helmy) May 31, 2026, 12:27am 1

Will there be an addition for LAG() or LEAD() functions that are in SQL added to ES|QL in the future?

Topic		Replies	Views
Elasticsearch query SQL Server LAG function analog Elasticsearch	1	1200	July 6, 2017
LEAD/LAG window function in elasticsearch Kibana painless , kql-kibana-query-language	5	1196	June 7, 2023
SQL interface to Elasticsearch & Aggregation functions Elasticsearch	3	1274	July 6, 2017
EQL implementation within Kibana or Roadmap Kibana	2	327	December 28, 2020
ES\|QL command join Kibana	2	1092	May 1, 2025

Elasticsearch is a trademark of Elasticsearch BV, registered in the U.S. and in other countries
Trademarks
Terms
Privacy
Brand
Code of Conduct

Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant logo are trademarks of the Apache Software Foundation in the United States and/or other countries.

LAG() LEAD() Functions in ES|QL

Related topics