In many cases, we have to do join other than primary key for the tables as same can't be configured with sync Record type and ultimately, we need to depend on Database views and we loose many capabilities of Sync Record type
Discussion posts and replies are publicly visible
Record relationships are there as a compliment to the joins between multiple records. And using relationships much of the features of views are replicable.