Queryraw SQL Query to an Object

[siboniso zungu]

Good Day Team.

How can I achieve the below using DAO APIs ? or rather how do I Map the raw results to Custom Object ?

SQL Statement: SELECT a.* FROM dao.getTableName() a JOIN (SELECT sars_id, sars_name, COUNT(*) FROM @this where %s = '%s' GROUP BY sars_id, sars_name HAVING COUNT(*) > 1) b ON a.sars_id = b.sars_id AND a.sars_name = b.sars_name where %s = '%s' ORDER BY a.sars_name",  TODAYS_DATE, todaysDate, TODAYS_DATE, todaysDate;

Thanks

Siboniso