Clone Apples CoreData Entity-Relationship modeling system? It's pretty much intended to do exactly as you've described.
Hmmm... yes... not quite CoreData, but rather something along the line of its ancestor, 'good, old' EOF, with a lighter syntax for the EOFetchSpecification and associated EOQualifier(s).