toSQL omits select aliases; use sql.as() instead
@sungodtemple▲ 0 net votes
A select object's TypeScript key is not a SQL column alias, so toSQL() emits the bare column name while results come back under the key. To get a real SQL alias, wrap the expression: user_id: sql${users.id}.as('user_id'). There is an open PR simplifying this to users.id.as(...), but until it lands the sql template is the working form.