Typescript is magic: https://kysely.dev/docs/examples/select/aliases

    const persons = await db
      .selectFrom('person as p')
      .select([
        'first_name as fn',
        'p.last_name as ln'
      ])
      .execute()