For now … it seems that Active Record it’s the way to go. This allows me to concentrate all the queries to the database in just one point without keeping table or view references in the code. Also at this level I can implement a caching system if needed. I already generated a set of classes for each table using FuelGenerator.

Basically using this pattern I only work with one record at the time, the current record is represented as an instance of class that holds a description of the table or view entity. There is another layer which makes all the calls to the database. I’m still working on this class to solve all the glitches.