i'm looking for advice on whether or not to start using PEAR DataObjects in my project. One thing i'm worried about is that i am planning on doing requires fairly complicated queries and I'm worried that I will run into limitations for how much the DataObjects can accomodate. If there is one aspect of the query that can't be set for the object using DataObjects methods then the query will have to just be written in SQL, and no established properties will be useable, correct?
for example, if I set a bunch of object variables, a join using joinAdd(), a group by statement using GroupBy() but then am not able to add a second join on the joined object, or can't get the query do do a full-text boolean search, then the I have to rewrite the whole query in SQL, correct?
One area i'm worried about that i haven't seen any documentation on is DataObject's ability to accomodate subqueries. For example, if i want to do a query like
Find sum from (SELECT sum(numbers) as sum from tb2 group by id) as tb1
i don't think i could incorporate it into the querying methods established in the DataObject package. In which case the DataObjects would cease to be useful. Does any one have any advice?
