Has anyone found a way to use the DISTANCE function in a SELECT phrase. I've seen how to use it in the WHERE and ORDER BY clauses, but what I'm trying to do is something like...
SELECT id, name, location, DISTANCE(location, GEOLOCATION(lat, lon), 'mi') FROM CONTACT;
Why? I want to show the distance to users in the UI, rather than just sorting by distance.