Example: Change Detection
A customer (self) is in a department (self.department) and may want to see only the current promotions of products in this department (MyPromotions)
let MyPromotions be
select I.*
from I in Catalog.promotions.item
where I.department = self.department