FetchXML seems to be a quirky subset of the SQL implemented in XML and optimized for UI tasks, including:
- the ability select specific fields (
foo
,b.bar
) or all fields (*
) from an entity - perform
LEFT OUTER
andINNER
joins - assign aliases to attributes (
select a.b as foo
) and (joined) entities (left join foo as BAR
)