Query stops when the app is wrapped with async wrapper

It can only be reproduced with the following usage.

I have a cli application that is using mysql2/promise

const app = new AppController(...)//...takes in all the db stuffs
(async () => {
  tempDb = createPool({
    host: process.env.TEMP_MYSQL_HOST,
    user: process.env.TEMP_MYSQL_USER,
    password: process.env.TEMP_MYSQL_PASS,
    database: process.env.TEMP_MYSQL_DB,
  });
  
  console.log(await tempDb.query("SELECT 1"); // this will stop the app from running and exited 0(zero)
  await app.run();
})();

It will only work if I use TSC to compile the app into commonjs with no async await but only promise by writing as

const app = new AppController(...)//...takes in all the db stuffs
await app.run(); //queries inside will work and returns correctly

May I know why?

Start with the mysql2/promise entry point and reproduce the supplied CLI example, comparing the async-wrapper and compiled CommonJS cases. Trace the query call and process lifetime around app.run; done when the query and app.run complete instead of the process exiting early, with a regression test covering the reproduction.