This is a cache of https://www.elastic.co/search-labs/blog/category/esql. It is a snapshot of the page at 2025-09-13T01:06:07.773+0000.
ES|QL - Elasticsearch Labs

ES|QL

September 9, 2025

Introducing the ES|QL query builder for the Python Elasticsearch Client

Learn how to use the ES|QL query builder, a new Python Elasticsearch client feature that makes it easier to construct ES|QL queries using a familiar Python syntax.

Introducing the ES|QL query builder for the Python Elasticsearch Client
Using ES|QL COMPLETION + an LLM to write a Chuck Norris fact generator in 5 minutes

August 28, 2025

Using ES|QL COMPLETION + an LLM to write a Chuck Norris fact generator in 5 minutes

Discover how to use the ES|QL COMPLETION command to turn your Elasticsearch data into creative output using an LLM in just a few lines of code.

Introducing a more powerful, resilient, and observable ES|QL in Elasticsearch 8.19 & 9.1

July 29, 2025

Introducing a more powerful, resilient, and observable ES|QL in Elasticsearch 8.19 & 9.1

Exploring ES|QL enhancements in Elasticsearch 8.19 & 9.1, including built-in resilience to failures, new monitoring and observability capabilities, and more.

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

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.

Timeline of ES|QL improvements

July 17, 2025

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 in JavaScript: Leveraging Apache Arrow helpers

June 9, 2025

ES|QL in JavaScript: Leveraging Apache Arrow helpers

Learn how to use ES|QL with JavaScript Apache Arrow client helpers.

How we rebuilt autocomplete for ES|QL

How we rebuilt autocomplete for ES|QL

How we rearchitected an autocomplete engine for ES|QL to support language evolution instead of resisting it.

ES|QL Joins Are Here! Yes, Joins!

April 15, 2025

ES|QL Joins Are Here! Yes, Joins!

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

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