Daobab brings amazing integration between SQL Query and Java and totally new approach to Object-Relational Mapping.
SQL: SELECT pizza.name FROM pizza Pizza where pizza.name='MARGHERITA' or pizza.name like '%PEPPERONI%' order by pizza.pizza_id asc;
Daobab: Select.fieldList(dao.colName()) .where(Where.OR() .or(dao.colName(),"MARGHERITA") .or(dao.colName(),Operator.LIKE,"%Pepperoni%")) .orderAsc(dao.colPizzaId()) .result();
Has functionality to execute SQL Queries at in-memory buffers to speed up the application by minimise the database usage.
Since Query is a Java source code, IDE is used as both SQL and code validator and integrator between queries and entities. SQL Query does'n have to be separated from main logic and can be maintain together with source code.