Today we release a new release of greenDAO with two new major features: a builder for queries, and result lists that load data on the go. The new QueryBuilder class lets you build custom queries for your entities. Before we introduced QueryBuilder, you could do the same with formulating SQL. The QueryBuilder spares you the SQL part and has other advantages like compile time checks, and lazy loading of results. Lazy loading creates entities on the fly when you need it (on-demand).
Check out the new Queries page in the documentation section for details and how to use the new features.