Add the ability to connect to a relational database, run a query and export the result as insert statements

I need to populate a table with summarized data from another table. Maybe the solution is to connect to a relational database, run a query and export the result as csv. Then use the csv to generate the inserts for another table.