Good point. I think it’s just a oversight in the design of FK join. I don’t see any reason why we would need to limit the FK-extractor to only user the value as input.
Can you file a Jira ticket for this?
I cannot think of any other workaround right now, but believe what you do (duplicate the FK key column into the value) is the only way to make it work right now.