title: How to excute Raw SQL Query on NestJS framework using typeorm
body: <p>I am going to execute such a long query on the NestJS framework using Typeform.
  Please let me know how to execute this query.</p>
  <pre><code>select user.id, user.fullName, (select count(*) sendCnt from chat where senderId = user.id), (select count(*) recvCnt from chat where receiverId = user.id) from users user where user.role = 'Admin'
  </code></pre>