Creating a table from a table?

Creating a table from a table?

Ok, I see that I can create a table from a csv. And I can save a query of that table. However, I am unable to reference that query in another query. It seems that I can only reference real tables from a query. That makes it difficult to integrate multiple data sources, each with their own set of calculated column, and then perform aggregation on them.

So I'm hoping for a way to either create a table from another table, or reference a query from another query, or use inline views, or something of that nature.