Can raw vault data be created from the equivalent of complex SQL?

Is it possible to create raw vault data from the equivalent of 'complex' SQL statements, using e.g. self-joins and joins to other tables, without using views?

For example, we have a number of hubs and satellites that we would like to create based on query result sets rather than being sourced from single tables. Can vaultspeed support this type of operation? Some SQL describing the sort of thing I am talking about is:

SELECT 
    a.<hub key>,
    a.<sat_a col1),
    b.<sat_a col2>
FROM
    a 
    JOIN (
        SELECT 
            FROM a
        WHERE 
            ...) b
        ON b.<column> = a.<column>
    JOIN c
        on c.<column> = b.<column>