I'm attempting to run the following type of query using createQueryBuilder . I've verified that all of my entities are properly created and joined. However, running the following returns an empty array:

let apiKey = await getConnection() .createQueryBuilder() .from(ApiKey, "apiKey") .innerJoinAndSelect("apiKey.site", "site") .where("site.domain = :domain", { domain: "mysitename.com" }) .andWhere("apiKey.key = :key", { key }) .getMany()

But! When I replace getMany() with getSql() , copy the raw SQL and run it, it works! I get the result I expected:

SELECT "site"."id" AS "site_id", "site"."domain" AS "site_domain", "site"."name" AS "site_name", "site"."createdAt" AS "site_createdAt", "site"."apiKeyId" AS "site_apiKeyId", "site"."userId" AS "site_userId" FROM "api_key" "apiKey" INNER JOIN "site" "site" ON "site"."id"="apiKey"."siteId" WHERE "site"."domain" = 'mysitename.com'

Is there any thing obviously wrong with how I'm trying to build this query?

Thanks in advance for the help!