One thing I'd noticed a while back was that it tends to generate LEFT OUTER JOINS instead of plain old LEFT JOINS, which isn't really bad, But thats one of the reasons (besides just being plain lazy) that I'm still sticking with pl/pgsql functions for most of my aggregation needs.