Is there a way to use SQL like terminology but instead of accessing a
database use DataSets?

I ask because in the current project I am doing there is need to create
tables dynamically as results of queries.  These tables are then used
proceed to the next step.

In a server environement I can see where if several people were doing the
same task and creating the same table there would be conflicts.  So I
thought, what if I could generate DataSets and then manipulate them in
memory without creating temporary tables in the database to do the work.
However, outside of setting up simple parent-child relationships(joins) for
DataSets I don't see many options in manipulating relations between
datasets.

For instance, I would need to create joins between DataSet and tables in a
database.  I also need to create Cross Joins between datasets.

Thank you in advance,

Eric