title: How to pass list of nested lists into JPA native query
body: <p>I need to create a JPA native query relevant to the example below:</p>
  <pre><code>select * from inventory where (server, product) in (('server1','product1'), ('server2','product2'), ('server1','product3'));
  </code></pre>
  <p>I have created a native query:</p>
  <pre><code>@Query(
              value = &quot;select server, product from inventory where (server, product) in (:myList)&quot;,
              nativeQuery = true
      )
      List&lt;Product&gt; getProducts(List&lt;List&lt;String&gt;&gt; myList);
  </code></pre>
  <p>But when I pass List of Lists as an argument:</p>
  <pre><code>List&lt;List&lt;String&gt;&gt; myList= Arrays.asList(
      Arrays.asList(&quot;server1&quot;,&quot;product1&quot;),
      Arrays.asList(&quot;server2&quot;,&quot;product2&quot;),
      Arrays.asList(&quot;server1&quot;,&quot;product3&quot;)
  );
  List&lt;Product&gt; products = myRepository.getProducts(myList);
  </code></pre>
  <p>I get an error</p>
  <pre><code>java.sql.SQLSyntaxErrorException: ORA-00920: invalid relational operator
  </code></pre>
  <p>I use Oracle database. Please tell me, what am I doing wrong?</p>
  <p>This question is <strong>not about passing a flat List</strong> into a native query to filter db results by 1 column (this works fine) but how to pass <strong>a list of nested lists</strong> into a query <strong>to filter db results by 2 columns</strong>.</p>