how to key/value iterate in stored function

I want to create a variable that is an array or list of key/value pairs.

The key would be a table name and the value would be a sql statement or
a value or list of values for which I could extract to create a sql
statement and execute.

I have tried experimenting with various arrays, but there is no clear
example or documentation.  The key and the value would be text.

I want to iterate over the entire array (or list), so would need an
example on that or some pointers there, if there is help.


J.V.