title: Select attributes from different joined tables with Flask and SQLAlchemy
body: <p>Can't get myself to do something as easy as good ol'</p>
  
  <pre><code>SELECT phrase.content, meaning.content
  FROM phrase JOIN meaning
  ON phrase.id = meaning.phrase_id
  </code></pre>
  
  <p>All the examples I can find in the documentation/SO are variations of</p>
  
  <pre><code>a = Phrase.query.join(Meaning).all()
  </code></pre>
  
  <p>which doesn't really work cause then <code>a</code> is a list of <code>Phrase</code> objects, whereas I want to select one attribute from <code>Phrase</code> and one from <code>Meaning</code>.</p>
  
  <p>Anybody? Thanks</p>