# Can ES SQL do things JSON search DSL can't?

**URL:** <https://discuss.elastic.co/t/can-es-sql-do-things-json-search-dsl-cant/248741>\
**Category:** Elasticsearch\
**Tags:** elastic-stack-sql\
**Created:** [September 15, 2020, 9:51pm UTC](https://discuss.elastic.co/t/can-es-sql-do-things-json-search-dsl-cant/248741 "2020-09-15T21:51:07Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dvisz-inf](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dvisz-inf/32/42617_2.png) [@dvisz-inf](https://discuss.elastic.co/u/dvisz-inf)\
**Post date:** [September 15, 2020, 9:51pm UTC](https://discuss.elastic.co/t/can-es-sql-do-things-json-search-dsl-cant/248741/1 "2020-09-15T21:51:07Z")

</div>

Hi all,

I've been working with Elasticsearch a lot for the past two years.

Although I come from a relational background, I've avoided using ES' SQL altogether, assuming that it couldn't do anything that the ES JSON search DSL couldn't do and that SQL was only provided for users who are more familiar with SQL and where SQL might be more succinct.

Do I have the wrong idea? Can ES SQL do things that ES search JSON DSL can't do?

Thanks!

---

<div class="post-metadata">

**Author:** ![warkolm](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/warkolm/32/39224_2.png) [@warkolm](https://discuss.elastic.co/u/warkolm)\
**Post date:** [September 15, 2020, 9:52pm UTC](https://discuss.elastic.co/t/can-es-sql-do-things-json-search-dsl-cant/248741/2 "2020-09-15T21:52:00Z")

</div>

It gets converted to the core DSL behind the scenes, so nope.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [October 13, 2020, 9:52pm UTC](https://discuss.elastic.co/t/can-es-sql-do-things-json-search-dsl-cant/248741/3 "2020-10-13T21:52:16Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
