There are some devices that have separate configuration and status tables for e.g. access points.
With these devices, if a configured object is down, the status entry for the given object will be missing.
To support getting both the up/down status of these objects and the status values of objects that are up, I would like to see the possibility of adding a join type where missing rows in the right table are replaced with rows with all empty or default values.
This would be equivalent of adding the .DefaultIfEmpty() linq modifier to the inner (right) table, or specifying a left outer join in a SQL query.
