As far as I know MS Query is only a tool that binds a SQL query statement to an ODBC database connection. It can be used in MS Excel, but also in MS Access. Typically you use it in Excel to pull n x m table data from a data source into a spreadsheet.
The database connection is only used while the the data is extracted from the database. Depending on the amount of data this is mostly done in less than 2 or 3 seconds. (And even if it takes longer you will see the hourglass pointer and all further data input is blocked). In other words if you have 2 or 3 queries stored in the MS Query builder and you use them in MS Excel, they are actually used sequentially and not in parallel.
Right, at the end you will have the data from all the data sources in your spreadsheet (in parallel), but this is cached data.
You can do the same in Calc with some manually composed macros as in this other thread
or there is also a more user friendly method to do this. I am not aware right now where I exactly saw this, but you might search in the Calc and Base forums for post with the keywords "insert from a database table".
OpenOffice 3.1.1 (2.4.3 until October 2009) and LibreOffice 3.3.2 on Windows 2000, AOO 3.4.1 on Windows 7
There are several macro languages in OOo, but none of them is called Visual Basic or VB(A)! Please call it OOo Basic, Star Basic or simply Basic.