Snowflake Stored Procedure for Query Execution

I'm seeking an experienced Snowflake developer to assist with a stored procedure. This procedure needs to execute approximately 100 SELECT queries that are stored in a table column. The results should be stored in a separate table, with each query's result being stored separately. There's no need for data transformation or processing before storage; I want the raw data stored as is.

The ideal candidate will have:
- Extensive experience with Snowflake and SQL
- Proven ability to develop and implement stored procedures
- Familiarity with executing multiple queries and handling their results

Please note that the data in the table columns is structured as SQL queries.