typeorm raw query
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]);