title: How to use knex with async/await?
body: <p>I'm trying to use Knex with async/await since Knex has a Promise interface. My code is below.</p>
  
  <pre><code>const db = makeKnex({
    client: 'mysql',
    connection: {
      host: process.env.MYSQL_HOST,
      user: process.env.MYSQL_USER,
      password: process.env.MYSQL_PASSWORD,
      database: process.env.MYSQL_DATABASE,
    },
    pool: { min: 0, max: 100 },
  });
  
  async function getUsers() {
    return await db.select()
    .from('users')
    .limit(10);
  }
  const res = getUsers();
  console.log('KNEX', res);
  </code></pre>
  
  <p>I expected to get the rows of my query back, but the output is</p>
  
  <pre><code>KNEX Promise {
  _c: [],
  _a: undefined,
  _s: 0,
  _d: false,
  _v: undefined,
  _h: 0,
  _n: false }
  </code></pre>