How can I map an object with the DB's column names as keys to an object with the columns' aliases as keys?

[csimmons0]

If I have a table like this:

pgTable(...
    fooBar: text("foo_bar").notNull(),
    barBaz: text("bar_baz").notNull(),
}

and I'm manually writing a SQL expression and directly calling the execute function on the whole expression

const {rows} = await db.execute(sql`...`)

such that each element of rows has the shape

{ foo_bar: value1, foo_baz: value2}

Is there an easy way to change the shape to

{ fooBar: value1, fooBaz: value2}

which is the shape of my table's $inferSelect type?

P.S. I wouldn't have this problem if we merged the PR for supporting lateral joins, which has been sitting still for nearly a year since the author made the latest set of requested changes.