I am part of the team working on this system. Yes, the SQL implementation will support left outer and inner joins. Thanks.