title: How to remove prefix from returned columns in typeorm querybuilder
body: <p>I set following querybuilder in typeorm.</p>
  <pre><code>const sql = this.attendanceRepository
        .createQueryBuilder(&quot;attendance&quot;)
        .leftJoin(&quot;attendance.child&quot;, &quot;child&quot;)
        .select(&quot;attendance&quot;)
        .addSelect(&quot;CONCAT_WS(' ', child.firstName, child.middleName, child.lastName)&quot;, &quot;childName&quot;)
        .addSelect(&quot;child.class&quot;)
        .where(&quot;attendance.id= :id&quot;, { id: id})
        .getRawOne()
        const Result = await sql
  </code></pre>
  <p>That querybuilder produces following <code>SQL</code></p>
  <pre><code>SELECT `attendance`.`id` AS `attendance_id`, `attendance`.`child_id` AS `attendance_child_id`,
  `attendance`.`attendance_cd` AS `attendance_attendance_cd`, `attendance`.`come_home_time` AS `attendance_come_home_time`, `attendance`.`late_time` AS `attendance_late_time`, `attendance`.`memo` AS `attendance_memo`, `attendance`.`created_at` AS `attendance_created_at`,
  `attendance`.`updated_at` AS `attendance_updated_at`, `attendance`.`deleted_at` AS `attendance_deleted_at`, `child`.`class` AS `child_class`, 
  CONCAT_WS(' ', `child`.`first_name`, `child`.`middle_name`, `child`.`last_name`) AS `childName` 
  
  FROM `attendances` `attendance` 
  LEFT JOIN `children` `child` 
  ON `child`.`id`=`attendance`.`child_id` 
  WHERE ( `attendance`.`id`= ? ) 
  AND ( `attendance`.`deleted_at` IS NULL )
  </code></pre>
  <p>It returned folloiwng data.</p>
  <pre><code>{
      &quot;attendance_id&quot;: 2,
      &quot;attendance_child_id&quot;: 4,
      &quot;attendance_attendance_cd&quot;: 3,
      &quot;attendance_come_home_time&quot;: &quot;11:50:00&quot;,
      &quot;attendance_late_time&quot;: &quot;23:40:00&quot;,
      &quot;attendance_memo&quot;: &quot;test&quot;,
      &quot;attendance_created_at&quot;: &quot;2020-10-16T13:33:00.053Z&quot;,
      &quot;attendance_updated_at&quot;: &quot;2020-10-19T10:34:55.000Z&quot;,
      &quot;attendance_deleted_at&quot;: null,
      &quot;child_class&quot;: &quot;S&quot;,
      &quot;childName&quot;: &quot;hikaru hikaru&quot;
  }
  </code></pre>
  <p>But my desired result is folloiwng</p>
  <pre><code>{
      &quot;id&quot;: 2,
      &quot;child_id&quot;: 4,
      &quot;attendance_cd&quot;: 3,
      &quot;come_home_time&quot;: &quot;11:50:00&quot;,
      &quot;late_time&quot;: &quot;23:40:00&quot;,
      &quot;memo&quot;: &quot;test&quot;,
      &quot;created_at&quot;: &quot;2020-10-16T13:33:00.053Z&quot;,
      &quot;updated_at&quot;: &quot;2020-10-19T10:34:55.000Z&quot;,
      &quot;deleted_at&quot;: null,
      &quot;child_class&quot;: &quot;S&quot;,
      &quot;childName&quot;: &quot;hikaru hikaru&quot;
  }
  </code></pre>
  <p>How can I remove prefix <code>attendance_</code> ?</p>
  <p>If someone has opinion, please let me know.</p>
  <p>Thanks</p>