Doctrine needs support for union all

The following query cannot be retrieved as objects. The following will work with ->fetchAll(). However, the result set will return as an array. I need this to be as an object.

return Doctrine_Manager::getInstance()>getCurrentConnection()>fetchAll("

SELECT

v1.*

FROM (
SELECT
'song_comment' as user_action,
null as artist_id, user_id, song_id, null as video_id, null as event_id, null as ip_address, null as is_going,
comment, created_at
FROM tbl_user_song_comment
UNION ALL
SELECT
'videocomment' as user_action,
null as artist_id, user_id, null as song_id, video_id, null as event_id, null as ip_address, null as is_going,
comment, created_at
FROM tbl_user_video_comment
UNION ALL
SELECT
'event_comment' as user_action,
null as artist_id, user_id, null as song_id, null as video_id, event_id, null as ip_address, null as is_going,
comment, created_at
FROM tbl_user_event_comment
) AS v1

ORDER BY created_at DESC

");

In summary, what I am trying to do is select all comments from tbl_user_song_comment, tbl_user_video_comment and tbl_user_event_comment and order by date (created_at).

The following ticket at http://trac.doctrine-project.org/ticket/18 should have been implemented!
There is no way in Doctrine to ->select() a view. In this case 'v1', since ->from() only expects a class!