SysEspressions (ranges) cannot be applied on an AOT query containing join types different from inner and outer join.

Symptom: This is because inside SysExpression.buildDataSourceChildMap() the datasources different from inner or outer join will be disabled. Why is this? The query will behave differently then it was build for.
Cause: I was discussing this case directly with Product Team, and based on his feedback this is a Product Limitation, the current scenario is not supported right now.
Resolution:
The feedback received is that the behavior of SysExpression.buildDataSourceChildMap() with inner and outer joins are by design and the scenario is not supported right now in the application, that’s why these type of datasources are disabled during the run.
I encourage you to create a new idea on our Ideas Portal, and if possible with title: “add outer join support to SysExpression” for better visibility. Please share this new idea with all your colleagues to get as many votes as possible. Product Team monitors the Ideas Portal to keep in mind all your feedback for future improvements of the Product. In addition, they are aware of this one because I shared with them.