Unless we hear back from OP I tend to agree with Rotem Yakir's assessment here. The idea is simply that the inner join is semantically what happens. How that happens depends on the Dialect and where/how the SQL is being generated. The last part is because we actually (currently) generate SQL differently in multiple situations. That is being actively fixed.