Here's one example of a common complication: Let's say your apple example is for an apple trading app. Each house is related to 2 boxes. One is available_for_trade_box_id and another is save_for_eating_box_id. How does your auto join tool know which to use?