title: SQL Equivalence of Solr Query
body: <p>In my spring boot project, i connect to a solr server. Instead of solr queries I need to use sql queries. I can get expected results for basic queries like <code>select * from reportCore</code>, but I cannot add filters or specify field names.
  What i would like to to is to find sql query equivalence of the following solr query; </p>
  
  <pre><code>id:123 OR reportName:"Promotion"
  </code></pre>
  
  <p>something like</p>
  
  <pre><code>select id, price from reportCore where id=123 or reportName="Promotion" 
  </code></pre>
  
  <p>Is there a way to do that or do I have to convert sql queries to solr ones. By the way, i use solr 6.1.0 </p>