With mysql2 for Node (with connection pool) & typescript,
try {
const [result] = await pool.execute<ResultSetHeader>(/* QUERY */,
[
/* PARAMS */
])
return result.affectedRows
} catch (e) { //etc