allow resources with many pipes (ie. partitioned resources)

[rudolfix]

Background Each resource has a single execution pipe that yields items when extracted. We want to support resources with many pipes that can yield items against the same resource schema. This allows to create resources that extract several files or several partitions of the same table easily.

Currently if source tries to create two resources with the same name, we get an error. The intended behavior was to create a resource with additional pipes.

Requirements

1. • [ ] allow to add secondary pipes to a resource
2. • [ ] update the source that if a resource with the same name is returned/added we add the pipe to the existing resource and apply hints from new resource (we can add table_variant if the new resource affects different table_name)
3. • [ ] update DltResourceDict to handle additional pipes. there's plenty of code that is accessing _pipe property of a resource

Tests We need to test several low level operations on the resources.

1. cloning and calling
2. iterating (as part of resources and source)
3. async generators and parallel extraction should work (pipes should be parallelized)
4. DltResourceDict tests must be extended to resources with multiple pipes. adding new resources, generating dag etc. are all to be checked
5. standard end to end tests