typeorm raw sql
snippet in sql

typeorm raw sql

user1807

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

typeorm raw query

user6236

  import { getManager } from 'typeorm';

  const entityManager = getManager();
  const someQuery = 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]);