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 8, 9, 10 , 11 no module-info
Java 6, 7
Java 9, 10 , 11 with module-info
From 7.0.0 you will need explicitly include the sql2o dependency in your pom.