If it was that simple, it would already have been solved. The problem is that relations are for any data point and they can be one-to-one, one-to-many, or many

If it was that simple, it would already have been solved. The problem is that relations are for any data point and they can be one-to-one, one-to-many, or many-to-many; and mixes metadata with data seamlessly. It's a hard problem, make no mistake, but completely solvable. I have an approach I'm working on that I'll email you, if you're interested.