This is a cache of https://www.elastic.co/search-labs/blog/category/esql. It is a snapshot of the page at 2025-08-01T00:52:06.229+0000.
ES|QL - Elasticsearch Labs

ES|QL

July 29, 2025

Unify your data: Cross-cluster search with ES|QL is now generally available!

Cross-Cluster search with ES|QL is now GA! Query data across multiple clusters with a single, elegant query. Learn about its performance, resilience, and syntax.

Unify your data: Cross-cluster search with ES|QL is now generally available!
Timeline of ES|QL improvements

Timeline of ES|QL improvements

Let’s walk through the history of ES|QL and its improvements.

Geospatial distance search with ES|QL

June 11, 2025

Geospatial distance search with ES|QL

Exploring geospatial distance search in Elasticsearch Query Language (ES|QL), one of the most desired and useful features in Elasticsearch's geospatial search and in ES|QL.

ES|QL Joins Are Here! Yes, Joins!

ES|QL Joins Are Here! Yes, Joins!

Elasticsearch 8.18 includes ES|QL’s LOOKUP JOIN command, our first SQL-style JOIN.

Native joins available in Elasticsearch 8.18

April 15, 2025

Native joins available in Elasticsearch 8.18

Exploring LOOKUP JOIN, a new ES|QL command available in tech preview in Elasticsearch 8.18.

Improving the ES|QL editor experience in Kibana

December 31, 2024

Improving the ES|QL editor experience in Kibana

With the new ES|QL language becoming GA, a new editor experience has been developed in Kibana to help users write faster and better queries. Features like live validation, improved autocomplete and quick fixes will streamline the ES|QL experience.

How to use the ES|QL Helper in the Elasticsearch Ruby Client

October 24, 2024

How to use the ES|QL Helper in the Elasticsearch Ruby Client

Learn how to use the Elasticsearch Ruby client to craft ES|QL queries and handle their results.

From ES|QL to native Pandas dataframes in Python

September 5, 2024

From ES|QL to native Pandas dataframes in Python

Learn how to export ES|QL queries as native Pandas dataframes in Python through practical examples.

An Elasticsearch Query Language (ES|QL) analysis: Millionaire odds vs. hit by a bus

August 20, 2024

An Elasticsearch Query Language (ES|QL) analysis: Millionaire odds vs. hit by a bus

Use Elasticsearch Query Language (ES|QL) to run statistical analysis on demographic data index in Elasticsearch.

Ready to build state of the art search experiences?

Sufficiently advanced search isn’t achieved with the efforts of one. Elasticsearch is powered by data scientists, ML ops, engineers, and many more who are just as passionate about search as your are. Let’s connect and work together to build the magical search experience that will get you the results you want.

Try it yourself