# Is Elasticsearch SQL going to be in XPack? **URL:** \ **Category:** Elasticsearch\ **Created:** [July 26, 2018, 9:13am UTC](https://discuss.elastic.co/t/is-elasticsearch-sql-going-to-be-in-xpack/141723 "2018-07-26T09:13:20Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Drammy](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@Drammy](https://discuss.elastic.co/u/Drammy)\ **Post date:** [July 26, 2018, 9:13am UTC](https://discuss.elastic.co/t/is-elasticsearch-sql-going-to-be-in-xpack/141723/1 "2018-07-26T09:13:21Z")
Hi all, I'd love to be able to use the beta Elasticsearch SQL functionality but I don't want to waste time developing around something that we won't be able to afford should it only be released post-beta in the XPack. I've struggled to find any details on the Elastic's intentions for Elasticsearch SQL but I assume the api url being prefixed with \_xpack suggests this will be the case. I suspect a lot of people will waste time developing stuff with it only for it to be made unavailable by the high cost of the XPack... Can someone confirm or at least detail what the current intentions are? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 26, 2018, 9:39am UTC](https://discuss.elastic.co/t/is-elasticsearch-sql-going-to-be-in-xpack/141723/2 "2018-07-26T09:39:31Z")
Have a look at [https://www.elastic.co/subscriptions](https://www.elastic.co/subscriptions) And click on `Management & Tooling` in Elasticsearch. You'll see: ![image](https://us1.discourse-cdn.com/elastic/original/3X/0/3/03d398a9dee941212fe1f742b5e8b76416f9eb73.png) So it depends on what you are going to use. ---
**Author:** ![Drammy](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@Drammy](https://discuss.elastic.co/u/Drammy)\ **Post date:** [July 26, 2018, 9:46am UTC](https://discuss.elastic.co/t/is-elasticsearch-sql-going-to-be-in-xpack/141723/3 "2018-07-26T09:46:57Z")
Ah, thanks @dadoonet! I just want to query my Elasticsearch objects using SQL with some searching, filtering and grouping... Most of the queries will come from .net but our customers may wish to use BI tools as well. Is there somewhere I can learn what Elasticsearch SQL functions require the interpreter CLI and which require the JDBC client? ---
**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\ **Post date:** [July 26, 2018, 10:27am UTC](https://discuss.elastic.co/t/is-elasticsearch-sql-going-to-be-in-xpack/141723/4 "2018-07-26T10:27:41Z")
Think about JDBC as a Driver. ie. you want to integrate with your [NAME YOUR PREFERRED TOOL HERE] like a BI tool you mentioned and you'll need something like jdbc/odbc drivers. For the rest, ie call the http endpoint [http://elasticsearch:9200/\_xpack/sql](http://elasticsearch:9200/_xpack/sql) then the basic license allows it. For example Kibana Canvas will use that endpoint. ---
**Author:** ![Drammy](https://avatars.discourse-cdn.com/v4/letter/d/bbce88/32.png) [@Drammy](https://discuss.elastic.co/u/Drammy)\ **Post date:** [July 26, 2018, 10:33am UTC](https://discuss.elastic.co/t/is-elasticsearch-sql-going-to-be-in-xpack/141723/5 "2018-07-26T10:33:38Z")
Thanks @dadoonet for the straight forward explanation and prompt replies 🙂 . It sounds like we can use it for what we want it for and that if Clients want to use BI tools we'll have to talk them into buying the XPack. That's good news! ---
**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\ **Post date:** [August 23, 2018, 10:33am UTC](https://discuss.elastic.co/t/is-elasticsearch-sql-going-to-be-in-xpack/141723/6 "2018-08-23T10:33:39Z")
This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.