There are a few times I need to get a unique list of (Customers / Dates / etc. Right now, I have to create a BO in Aware then call a stored procedure to populate the BO. Not sure how you would / could implement a DISTINCT operator without having a list of fields to be selected (Yea, I know a FIND in aware will return ALL of the columns.)
Bruce