[rest_api source] Extend the resolve params to fetch an pass a list of parameters

### Feature description

Some APIs allow to pass a list of elements to collect further details on some resources, this is a way to limit the number of calls.

The idea would be something like:

```
"params": {
"resource_id": {
"type": "resolve_list",
"field": "id",
"resource": "parent_resource",
"list_size": 100
},
},
```

A few notes:
- this must work with query params (this is where usually you pass arrays). So [this issue](https://github.com/dlt-hub/dlt/issues/1978) needs to be solved too.
- would be nice to sort out [this](https://github.com/dlt-hub/dlt/issues/1873) too.
-

### Are you a dlt user?

Yes, I run dlt in production.

### Use case

APis accepting arrays of elements

### Proposed solution

Add an additional params type

### Related issues

_No response_