CodeIgniter database reporting library

We need a php reporting library for the CodeIgniter framework v2.x Today, we have an existing CodeIgniter v2.x application. We need someone to develop a reporting module for us, that is agnostic of our application. The library should live in the application/libraries directory, and be able to be loaded in models/controllers as needed without conflict. What this library will do / What we need We want to be able to pre-define relationships between tables, for instance table_a.user_id = table_b.user_id and also pass in an array of columns to select, any aggregations such as AVG([login to view URL]),SUM([login to view URL]) as well as group by column(s) and order by column(s) and limits, and have CI return the results. Table A may have 100 columns, but we only want to expose 20-30 columns to the user to be selected. (Same with table B..C...D). We want to store these configurations (either in a mysql table, or in xml... or some other format) The library should support multiple table joins, as well as being able to filter with the where clause. In the pre-defined relationships, we will also want to be able to add WHERE clauses that can't be over-written by the where clauses passed into parameters. For instance, (table_a.company_id =2 and table_b.company_id =2 ) always appended to the queries that are generated, so that we can restrict access to records by some columns. In our application, we are going to write these relationships and group them by category, so there may be several "user" reports, but they will share maybe 1 or 2 pre-defined relationships. The application also needs to be able to specify whether the tables in the relationship are left/right/inner joins as well and should be extremely modular and flexible with the aggregations, grouping, etc. I imagine something like this: $config = array('where' => array('user_id' => 2, 'date_col' => 'some_date'), 'group_by' => array()....); // etc... should support array and single values... $reportEngine = new ReportEngine(); // Call it whatever just a sample $reportEngine->loadReportType('users_with_addresses'); $reportEngine->setConfig($config); $data = $reportEngine->run(); The report would generate a query based on the template pre-defined relationship in the users_with_addresses table.... and then return the data. An example of the users_with_addresses relationship might be like "[login to view URL] JOIN [login to view URL] on (users.id=addresses.user_id) WHERE users.org_id = 4 " So the above example code may return a query that is like SELECT (some columns) from [login to view URL] JOIN [login to view URL] on (users.id=addresses.user_id) WHERE (users.org_id = 4) AND ( .... WHERe statements from config) We need this to use native CI db helper as well.