# Converting SQL to DSL or KQL

**URL:** <https://forum.opensearch.org/t/converting-sql-to-dsl-or-kql/6594>\
**Category:** SQL\
**Created:** [July 23, 2021, 3:12pm UTC](https://forum.opensearch.org/t/converting-sql-to-dsl-or-kql/6594 "2021-07-23T15:12:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![mrmet59](https://avatars.discourse-cdn.com/v4/letter/m/97f17d/32.png) [@mrmet59](https://forum.opensearch.org/u/mrmet59)\
**Post date:** [July 23, 2021, 3:12pm UTC](https://forum.opensearch.org/t/converting-sql-to-dsl-or-kql/6594/1 "2021-07-23T15:12:05Z")

</div>

Running ES Opendistro 7.9 SQL 1.10

From the documentation, I see there was an ability to convert SQL to DSL in “SQL Workbench”. In 1.10 “Query Workbench”, the button has been removed. I used “Explain” but it produces a mapping as output when run.

Is there a way in 1.10 that can convert SQL to DSL/KQL?

Thanks in advance,

Ed

---

<div class="post-metadata">

**Author:** ![kris](https://sea1.discourse-cdn.com/flex019/user_avatar/forum.opensearch.org/kris/32/2208_2.png) [@kris](https://forum.opensearch.org/u/kris)\
**Post date:** [February 7, 2023, 5:17pm UTC](https://forum.opensearch.org/t/converting-sql-to-dsl-or-kql/6594/2 "2023-02-07T17:17:43Z")

</div>

Closed on February 7, 2023, 5:17pm UTC