I'm trying to use Knex with async/await since Knex has a Promise interface. My code is below.

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);

I expected to get the rows of my query back, but the output is

KNEX Promise {

_c: [],

_a: undefined,

_s: 0,

_d: false,

_v: undefined,

_h: 0,

_n: false }