Sometimes there are only partial attributes available for the foreign query (from the current data set), and it would be nice to allow to configure extra step on the foreign query (only one level of depth), to fetch missing data from the intermediate table, and they use missing atribute values from that intermediate table query data result.
Ex.: Table1 Has only the partition key for the Table2 (foreign table), although at the same time Table1 Has the partition key for the Table3 from where the sort keys for the Table2 could be fetched, so the resulting query could look like this, for example:
Table2.Hash = Table1.Table2Id and Table2.Sort Between Table3.Value1 ad Table3.Value2
Sometimes there are only partial attributes available for the foreign query (from the current data set), and it would be nice to allow to configure extra step on the foreign query (only one level of depth), to fetch missing data from the intermediate table, and they use missing atribute values from that intermediate table query data result.
Ex.: Table1 Has only the partition key for the Table2 (foreign table), although at the same time Table1 Has the partition key for the Table3 from where the sort keys for the Table2 could be fetched, so the resulting query could look like this, for example:
where Table3 data is fetched by: