I think it&#x27;s the size of the ES query object as well as complexity... even the ES documentation provides SQL examples to explain the ES query object...<p>Here&#x27;s a good example:<p><a href="https:&#x2F;&#x2F;www.elastic.co&#x2F;guide&#x2F;en&#x2F;elasticsearch&#x2F;guide&#x2F;current&#x2F;combining-filters.html" rel="nofollow">https:&#x2F;&#x2F;www.elastic.co&#x2F;guide&#x2F;en&#x2F;elasticsearch&#x2F;guide&#x2F;current&#x2F;...</a><p>SQL:<p><pre><code>     SELECT document FROM products WHERE productID = &quot;KDKE-B-9947-#kL5&quot; OR (productID = &quot;JODL-X-1937-#pV7&quot; AND price=30)
</code></pre>
ES Query:<p><pre><code>    {
   &quot;query&quot; : {
      &quot;filtered&quot; : {
         &quot;filter&quot; : {
            &quot;bool&quot; : {
              &quot;should&quot; : [
                { &quot;term&quot; : {&quot;productID&quot; : &quot;KDKE-B-9947-#kL5&quot;}}, 
                { &quot;bool&quot; : { 
                  &quot;must&quot; : [
                    { &quot;term&quot; : {&quot;productID&quot; : &quot;JODL-X-1937-#pV7&quot;}}, 
                    { &quot;term&quot; : {&quot;price&quot; : 30}} 
                  ]
                }}
              ]
           }
         }
      }
   }
}</code></pre>