Pass a huge dataset to a query
After some digging around it does seem like write access can be granted but the constraint here is there should be no leftovers i.e no empty temp table lying around after the transaction is done.

Going with the temp table solution and dropping it at the end of the transactions.