I've seen this error recently with manually written SQL and I managed to fix it by moving the query providing the column mentioned in the error before the sub-query. You shouldn't have to do this with SQL as it should be order insensitive.
Are you able to do that in DI? If possible can you post the log containing the generated code with the error?
... View more