code: public <S> List<S> queryList(Class<S> type, String sql, Object[] params) {
          Connection conn = getConn();
          try {
              return conn.createQuery(sql)
                      .withParams(params)
                      .setColumnMappings(computeModelColumnMappings(type))
                      .throwOnMappingFailure(false)
                      .executeAndFetch(type);
          } finally {
              this.closeConn(conn);
              this.clean(null);
          }
      }
docs: Querying a list
  
  @param type   model type
  @param sql    sql statement
  @param params params
  @param <S>
  @return List<S>