title: Selectively loading backrefs in SQLAlchemy
body: <p>Following the examples here: <a href="http://docs.sqlalchemy.org/en/latest/orm/loading_relationships.html" rel="nofollow">http://docs.sqlalchemy.org/en/latest/orm/loading_relationships.html</a>, one can easily load <em>all</em> the addresses for the <code>User</code> with name Jack like so:</p>
  
  <pre><code>jack = session.query(User).options(joinedload('addresses')).\
         filter_by(name='jack').all()
  </code></pre>
  
  <p>However, there is no example for how to load only those addresses that match a certain criterion - let's say I only want those addresses from Jack that end with '@google.com'.</p>
  
  <p>Is this possible with SQLAlchemy - specifically, can I pass something to <code>joinedload()</code> or <code>subqueryload()</code> that allows me to filter addresses?</p>