EXEC in SAP HANA

Hi Experts,

Is there a way to store intermediate results that gets generated out of EXEC command into a temp table in SAP HANA SQL? I understand that we can use INTO to store single value result but i'm expecting tabular result and I really need to have EXEC command inside my code as the Stored Procedure is running Dynamically by fetching data from different tables.

Ex:

EXEC 'select column1, count(column1) from table 1 group by column1'

Thanks