create CB list based on query field

hello

is there a way to query the database and produce a list based on the query?

ie:

using CB lists, create a list based on the query

SELECT DATEDIFF('[cb_date1]',now())

where cb_date1 is a future date and the query shows on the website ho w many days to the date.

what i am after is to list all users, ranking them from least amount of days ( from the query ) to most.

the problem is that the CB list manager only allows fields to be used and not queries ( that i can figure out )

i was thinking there must be a way to substitute the query into a field, but am concerned that it will not be updated to the time the list is generated.

thanks

Yes, using incubator project CB Query Field you can output the results of a database query as a field, but I don't think you can use Calculated fields (fields that don't store to database) in the Sort By for a userlist.