title: SQLAlchemy SELECT id FROM Table_1 WHERE name='xyz'
body: <p>I can get the <code>SELECT id from parts where name='Part1'</code> as an SQL statement but what is the way to do that with SQLAlchemy?</p>
  
  <p>I've tried;</p>
  
  <pre><code>db.session.query(Parts.id).filter(name=form.name.data)
  </code></pre>
  
  <p>But this returns an Object not the <code>id</code></p>