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]);