SQLAlchemy SELECT id FROM Table_1 WHERE name='xyz'
<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>