Here is a simplified version of my models (Django 1.9, if that matters):
class Player(models.Model):
name = models.StringField()
class Match(models.Model):
player_1 = models.ForeignKey(Player, related_name="player_1")
player_2 = models.ForeignKey(Player, related_name="player_2")
Is there any way to add a player.matches field to the model, which would query all matches where the player is player_1 or player_2? Specifically, I want to do this to take advantage of select_related() to reduce n+1 queries when getting matches for each player
I know I can re-structure the database to support that, but would prefer not to.