Using queries

The API supports fluent queries similar to SQL. The first example finds all rows where President is Barack Obama

List<Row> rows = csv.findByQuery().where().column("President").is("Barack Obama").getResultList();

The second example uses sorting for the results

List<Row> rows = csv.findByQuery().orderBy().asc("President").getResultList();