A typical case of SQL relation: aggregating results from jdbc input plugin (nested)

I appreciate your response. It can be a direction for some needed solutions. But in my case, It still needs some more effort.

Can there be Aggregate(s) based on multiple fields, can there be multiple task_ids if yes what is the use case(s)
Is there anything Like the following

aggregate {
        task_id => "%{region_name}%{country_name}"

Thanks