title: JDBC template.queryForList() not working for preparestatement
body: <p>I wrote a Spring Boot code using jdbcTemplate.queryForList(String, Type, String...) method querying from postgresql database since the String formatting would have chance causing SQL Injection.
  The code is below:</p>
  <pre><code>String sql = &quot;SELECT arr.featurecodes FROM featurecapabilitydate,jsonb_array_elements(data-&gt;'features') with ordinality arr(featurecodes, position) WHERE data-&gt;&gt;'vin'= ? and arr.position in (select distinct arr.position  FROM featurecapabilitydate, jsonb_array_elements(data-&gt;'features') with ordinality arr(featurecodes, position) WHERE data-&gt;&gt;'vin'= ? and arr.featurecodes-&gt;&gt;'featureCode' in(?))&quot;;
          List&lt;String&gt; List = readpgjdbcTemplate.queryForList(sql, String.class, vin, vin, concatfeatures);
          if(!List.isEmpty()){
              return List;
          }
  </code></pre>
  <p>But the returned list is empty. May I ask what goes wrong here? Thanks.</p>