Does TypeORM supports raw SQL queries for input and output?

Question

I would like to know if there is a feature of TypeORM that supports raw sql queries for Insert Update Delete Select etc..

Answer 1

According to this issue comment, TypeORM enables you to use any queries to your heart's content. using entityManager.query() Here is the documentation.

UPDATE

Link above is outdated, try this instead entity-manager-api.

const rawData = await manager.query(`SELECT * FROM USERS`); 

Answer 2

2020 UPDATE, entityManager.query() basing the entityManager off the EntityManager class, was not working for me so had to do this:

  import { getManager } from 'typeorm';    const entityManager = getManager();   const someQuery = await entityManager.query(`   SELECT      fw."X",     fw."Y",     ew.*   FROM "table1" as fw   JOIN "table2" as ew     ON fw."X" = $1 AND ew.id = fw."Y";   `, [param1]); 

https://orkhan.gitbook.io/typeorm/docs/working-with-entity-manager