[SQLObject] Selecting a single column

[Mark <mar...@gm...>]

I need a single column of the table in list format format
based ie select col1 where foo. Can I do this? Can I 
write my own sql? Whats the most efficient way to do this? 

I seem to be uncomfortable using SQLObject because some of
my tables aren't really objects as much as linking tables. 
In this case we have a User who has friends so I added a 
Friends class (userid,friendid) which isn't really an 
object in my mind.