Result

When query is finally parametrised, and want to get a result, you have few choses

Every query result can be consumed and converted.
Instead of reading result directly, point a data consumer or mapper.

Instant result

This method returns a type safe, correct object, related to selected query.

So it can result an entity,field,projection or collections of those values.

Pizza pizza=Select.entity(db,tabPizza)
	.where(tabPizza.colPizzaId(),6)
	.result();

Instead of getting an result, you can simply provide a logic to consume it

Select.entity(db,tabPizza)
	.where(tabPizza.colPizzaId(),6)
	.consumeEntity( e-> myMethod(e));

Consume list one by one:

Select.from(db,tabPizza)
	.whereBetween(tabPizza.colPizzaId(),3,6)
	.result();

Convert list:

Select.from(db,tabPizza)
	.whereBetween(tabPizza.colPizzaId(),3,6)
	.map(Mapper::toCake)
	.result();

Filter list:

Select.from(db,tabPizza)
	.whereBetween(tabPizza.colPizzaId(),3,6)
	.filter(Filter::withCheese)
	.result();