title: How to query Apache Ignite using IN clause
body: <p>I've a schema created in Apache Ignite as follows:</p>
  
  <pre><code>---------------------------------------------
  EmpId | EmpName | HomeZip | OfficeZip| Dept |
  ---------------------------------------------
  1     | Sam     | 98123   | 98123    |  A   |
  ---------------------------------------------
  2     | Jack    |  98123  | 98123    |  B   |
  ---------------------------------------------
  3     | John    |  98124  | 98123    |  A   |
  ---------------------------------------------
  4     | Kim     | 98124   | 98123    |  C   |
  ---------------------------------------------
  </code></pre>
  
  <p>How can I do the followin queries:</p>
  
  <ul>
  <li>Find all details of employees in dept A.</li>
  <li>Find all details of employees whose homeZip is same as OfficeZip.</li>
  </ul>
  
  <p>How can I do this using the SQLQuery and map the response to the Model class</p>
  
  <pre><code>class Employee{
    private Integer empId;
    private String empName;
    private String homeZip;
    private String officeZip;
    private String dept;
  }
  </code></pre>
  
  <p>I tried querying it as follows but errors out for me: </p>
  
  <pre><code>//For finding out employee in list of departments
  SqlQuery sql = new SqlQuery(Employee.class, "dept in (?)).setArgs(deptList);
  //For finding out employee with same zip for office and home:
  SqlQuery sql = new SqlQuery(Employee.class, "homeZip = officeZip");
  </code></pre>