SQL tool that can use query result sets as temporary tables for further analysis and set operations?

Question

For examples, lets say I need to do set operations and joins on below result sets from 3 different SQL queries:

• I don't want to write a composite query with subqueries, or use temporary database tables, views or CTEs. In other words, no processing on the database server but on the client machine.
• I am not asking about GUI based query builders like SQLyog

Something which would enable faster data analysis using broken-down sets of data like below from a large database. It could be roughly like if you could join two result sets from two separate queries in Toad/SQL developer. (What I find myself doing now to achieve this is pasting multiple sets of data from each of these queries into MS excel and use vlookup() and further filtering etc.)

SQL Query 1 result: (T1)

Col1 Col2 
A    1
B    2

Query 2 result: (T2)

Col3 Col4 
1    #
2    *

Query 3 result: (T3)

Col5   
1     
3    

---

Required operation to be done on T1,T2,T3 from above is:

 Select T1.col1,T2.col4 
        from T1,T2 
        where T1.col2=T2.col3 
        and T1.col2 in (Select T3.col5 from T3)

(Not necessary that the tool generates SQL like above to process on top of the result sets, SQL above is only for conveying the logic I have in mind.)

Required result is:

Col1  Col4
1    #

[EDIT]

This was previously asked here on DBA.SE and has been migrated by the OP.

Answer 1

Using pandas data frames you can run an initial query, (or set of queries), to populate the data frames and then perform all of your joins, manipulation, reporting, exporting, etc. offline on the client machine.

Better yet you can create a script that will, on demand, perform all of the above actions so as to rerun your process with fresh data as needed.

It will probably be worth reading the comparison between Pandas and SQL page.

Answer 2

I will continue all correspondance about this issue here. As I suggested, you can still use XE with Oracle's heterogeneous services, you can connect to DB2 and MS SQL Server.

[EDIT]

You can connect SQL Developer using JDBC. Check here and here (first two results Googling "JDBC and Oracle SQL Developer), and esp. here (third result). Have "messed about" with MySQL using SQL Developer - give it a go.