Yes, would be nice but not in our immediate plans.
+1 from me on this as well.
For simplicity of writing, CodeIgniter's AR syntax (http://codeigniter.com/user_guide/database/active_record.html) takes a lot of beating.
I have a very simplistic version of this working. At this point it is more of a proof of concept, but it does work:
$finder = Person::finder()->where('age > ?', 18)
->order('age DESC');
$adults = Person::all($finder);
I did need to overload a couple ActiveRecord\Model methods, creating my own layer on top, but we could probably figure out a way around that. The issue was getting the ActiveRecord\Model class to treat the finder like an array (it does implement array access).
Is this something you would like to check out?
(1-3/3)
Subject: query object
have you guys considered creating a query object as an alternative option for composing select statements? At first I did not like the way ZF did this, but I think it makes complicated queries much easier to read and compose dynamically when compared to array notation.
Maybe something like this:
// find users created within the last month $result = User::find(Query::select() ->where('date_created > ?', $oneMonthAgo) ->order('name DESC'));