Node.js mysql Module Wait for Query Results

Question

I'm trying to do something that should be very straightforward. I need to wait for mysql query results so that they can be returned as an HTTP response. However, the only examples I can find simply write query results to the console and do not wait for results.

I've tried many approaches given online for generic wait/promise. Here's the latest one I tried using util.promisify() from this post; node.js async/await using with MySQL

Here is my sample code;

function callbackQuery(error: any, results: any, field: any) {
    if (error) {
      console.log(error);

      return {
        statusCode: 500,
        body: JSON.stringify({ message: 'There was an error' }),
      };
    } else {
      console.log(results);

      return {
        statusCode: 200,
        body: JSON.stringify({ message: 'There was NO error' }),
      };
    }
  }

  function queryWrapper() {
    connection.query('SELECT * FROM my_table', callbackQuery);
  }

  const myQuery = util.promisify(queryWrapper).bind(connection);

  (async () => {
    try {
      const res = await myQuery();
      console.log(res);

      return res;
    } finally {
      connection.end();
    }
  })();

And here are the results;

Request from ::ffff:127.0.0.1: GET /.netlify/functions/ ◈ lambda response was undefined. check your function code again Response with status 500 in 100 ms.[ RowDataPacket { } ]

So, essentially, no waiting is happening because the 'lambda response was undefined' is output before the query result set. I would expect the response, 'There was NO error' instead. Does anyone have a simple example of how to wait for the data?