Is there any software that combines spreadsheet and database engine functionality?
I would like to be able to paste two tables (for example results of SQL queries, with 20+ different columns each) and write a simple sql-like query to join the two tables and generate a third one. Or conditionally replace certain values, easily split string columns into two, etc.
I currently do this in Sql, for every little task like above I have to define temporary tables and keep track of all subqueries, which is a bit time consuming (again 20+ columns).
I've heard Power Query can help with this, but cannot use excel for various reasons, for example data formatting is still required - pasted data is usually incorrectly parsed, (big numbers are converted to exponential form, dates parsed as floats), and many more.
I am considering writing a script which would convert tables (csv's?) to an Sql table variable declaration and population script, but if there's an existing solution, I'd rather use that.
I would prefer free software, both Windows and Linux options would work.
However if you know of any software that can do this - please share!