Field renaming in query

[Schnurbus]

Hi,

Is it possible to rename the fields in a query?

Regards
Pascal

[MickL]

This would be SO useful to have!! Can we have this implemented as a feature request?

The only way I found so far is to use extras with sql:

await db.query.users.findMany({
   extras: {
      userName: sql`${users.name})`.as('userName'),
   },
})

While the name in .as() seems to be required but only used internally for the query.