XML SELECT Command
The CData Virtuality Server can dynamically construct complex XML documents using XML Document Object Models. A document model is generally created from a schema and is bound to the relevant SQL statements through mapping classes.
XML documents may also be created via XQuery with the XMLQuery
function or with other SQL/XML functions.
Querying XML documents is similar to querying relational tables. An idiomatic SQL variant with special scalar functions controls which parts of a given document should be returned.