title: How to get all values from same column?
body: <p>I am developing web framework using python. below is my database. this database name is fruit.</p>
  
  <pre><code>name     price
  -----    -----
  apple    $2
  pear     $2
  grape    $4
  </code></pre>
  
  <p>I am using SQLAlchemy. so class name is Fruit. What should I write to make result below list ..? I want to get values from 'name' column.</p>
  
  <p>['apple', 'pear', 'grape']</p>
  
  <p>and is there any way to execute SQL query directly ..?</p>
  
  <pre><code>sql_query = 'SELECT name FROM Fruit'
  Fruit.query.execute(&lt;sql_query&gt;)
  </code></pre>