fix: rewrite assoc chains if intermediate assoc is not fk

[patricebender]

in one case a ref genre.parent.ID was mistaken for a foreign key access because ID is fk of parent. But because parent is not fk of genre, it is actually not an fk access. Hence, the reference actually needs to point to the correct join node.