Although Sql2o provides a mapping implementation. It does not support inner objects, factory methods, or joins…
By adding just a 2 lines of code to your queries, you will gain the mapping power and
the performance of SimpleFlatMapper.
Give it a try.
Getting Started Sql2o
Setting up the environment
Add the Dependency to your build.
Java 6, 7