Symbolic SQL question

Hi,

I've been just trying to find symbolic equivalent
of the following SQL query (in order to call it
within DO-QUERY):

    select foo from (select foo from bar)

and the obvious solution doesn't work:

    [select [foo] :from [select [foo] :from [bar]]]

    Error: :TABLE argument to SQL-EXPRESSION is not
    a string, symbol, or sql identifier --
    #<SQL-QUERY "(SELECT FOO FROM BAR)">

I would be grateful for any ideas.

Jaroslaw