My colleague published a plugin that adds ES|QL support to IntelliJ IDEA: https://plugins.jetbrains.com/plugin/28898-elasticsearch-es-ql
It includes features like syntax highlighting and query validation, which can be useful if you don’t want to rely only on Kibana or Dev Tools when writing queries.
Sharing in case it’s relevant to others here:
https://www.elastic.co/search-labs/blog/esql-plugin-intellij-idea
Excited to share something Martijn Laarman and I have been working on: LINQ to ES|QL is now available in the Elasticsearch .NET client.
Starting with Elastic.Clients.Elasticsearch v9.3.4 and v8.19.18, you can write C# LINQ expressions that automatically translate into ES|QL queries at runtime. No more handcrafting query strings, just use the Where, Select, OrderBy, GroupBy, and other standard operators you already know (EntityFramework style).
Some highlights:
🔹 Automatic parameterization that prevents injection and enables query plan caching
🔹 Streaming materialization via IAsyncEnumerable<T> for constant memory usage
🔹 80+ ES|QL functions mapped to familiar C# methods
🔹 LOOKUP JOIN, aggregations, and server-side async queries all supported out of the box
🔹 Native AOT compatible
In the blog post, we dive deep into how it all works under the hood: the expression tree capture, the six-stage translation pipeline, the intermediate query model, and more.
If you're a .NET developer working with Elasticsearch, I'd love to hear what you think.
https://www.elastic.co/search-labs/blog/linq-esql-c-elasticsearch-net-client