Is it possible to have a child stream with two parents? Say I have a

Buildings

stream and a

Tenants

stream, and a

ServiceRequests

stream that requires a

building_id

AND`tenant_id` in the body of a post request (there is no GET/ list ServiceRequests endpoint). So I would iterate

Buildings

, then

Tenants

then iterate

ServiceRequests

with a full outer join of the two parents. Is that possible? https://www.linen.dev/s/meltano/t/16381950/hi-all-i-have-built-a-custom-tap-to-extract-data-from-an-api looks like a possible approach, basically I make my

Tenants

stream an artificial child of

Buildings

and then make

service requests

have

Tenants

as parent.

That's a good solution for the time being. I'm collecting similar cases in https://github.com/meltano/sdk/discussions/2846 (this looks like 3).