PhARoS

This class can compose SQL queries from lists from set of simple function calls. It provides a modified version of Active Record pattern to generate SQL queries.
Really simple and minimal PhARoS provides a minimal set of user routines to let you generate your standard SQL queries using modified version of active record pattern. Also taking away all the boiler level strings from the programmer making code simpler.

Since PhARoS is not dependent upon any of the databases classes at all, you can yourself choose how to query database either by directly using the functions (like mysql_query) or choose any of the databases abstraction libraries (adodblite or adodb itself).

As it is based on principle of minimalism and flexibility, that's why unlike any of the active record classes (Propel or Doctrine) it is plug n play and has no tight integration or complex XML configurations. All you will be doing is feeling the complete power to generate the queries with decent readable code. Unlike some libraries it only requires PHP 4+ version and that’s it. Although there is not much bloated code; still you will be able to use CRUD like methods to generate queries for you. They key routines are selectQuery, insertQuery, updateQuery, deleteQuery.