How do you SELECT with a pool?

[erikschul]

I'm struggling with something as simple as a SELECT query.

The return type has no properties except constructor. How do I access the results as rows?

const sql = `SELECT * FROM my_user WHERE id = ?`
const [rows] = await this.pool.query(sql, { id })

// rows has no properties

[erikschul]

I was able to get it to work with:

SELECT

forcing the type:

const sql = `SELECT * FROM my_user WHERE id = :id`
const [r] = await this.pool.execute(sql, { id })
for (let row of r as MyUser[]) {
  console.log(row.name)
}

INSERT/UPDATE

const [r] = await this.pool.execute<ResultSetHeader>(sql, data)
if (r.affectedRows != 1) throw `failed to add row`

It does add some boilerplate though. Is there a better approach?