@Test
public void testQueryBetween() throws Exception {

    SqlBuilder builder = selectAll().from(p).where(p.PeopleID.between(1, 3)).orderBy(p.PeopleID.asc()).into(Person.class);
    List<Person> pl = dao.query(builder);
    
    assertEquals(3, pl.size());
    assertEquals(1, pl.get(0).getPeopleID().intValue());
    assertEquals(2, pl.get(1).getPeopleID().intValue());
    assertEquals(3, pl.get(2).getPeopleID().intValue());
}