Typeorm of sql query

Question

This query works well on the database, however I'm not able to make it work by using typeorm createQueryBuilder.

SELECT *
FROM content 
INNER JOIN FreeTextTable(content, *, 'text') AS KEY_TBL
    ON content.id = KEY_TBL.[KEY]
ORDER BY KEY_TBL.RANK DESC

Could you please help me out here?

Answer 1

For those facing the same issue. I was unable to find a solution to use FREETEXTTABLE with typeorm, so I had to implement it using raw SQL.