title: Drift Flutter - Get Specific Field Value From Table
body: <p>I am using Drift for the first time and I have been able to create the tables in the database and insert into a table in the database. Now I want to show a field value from the table on my app, for example, a table called Employee that has the employee name in the &quot;name&quot; field, I want to be able to display the employee's name at the top right of the app when they log in. So I want to get the value of the name field for that employee.</p>
  <p>How can I achieve this?</p>
  <p>A lot of examples I see are for displaying Lists and that's not really what I'm looking for.</p>
  <p>I tried to do a get on the table but I don't know how to get the snapshot of the table's data.</p>
  <pre><code>Future&lt;List&lt;Employee&gt;&gt; getEmployee() async {
      return await select(employee).get();
    }
  </code></pre>
  <p>Please how can I achieve this?</p>