I'm using SQLObject 0.7.0 and I'm having lots of trouble retrieve a list of distinct columns from my table. What is the equivalent of the following in SQLObject?


Table: users

Columns: id, name, age


SELECT distinct name FROM users


The only way I can do the above is the following which uses raw sql statement:


c = users._connection

return c.queryAll('SELECT distinct name FROM users')


Is there an alternative way to do the above?