XML.SQLExport compared to XML.Export

Contrast XML.SQLExport and XML.Export:

XML.Export:

•Single-table: The FROM clause may only contain a single table name (naming a database table, Logical View, or component table)

•Simple output: The SELECT output list may only contain simple column names or the * wildcard. SQL functions and mathematical operators are not allowed.

•No meta-data: the output is raw data, as opposed to (also) information about how the data was computed. No reference is made to the origin of the data: a relational database with tables and columns.

XML.SQLExport:

•Multi-table: the FROM clause may contain any number of table names.

•Full SQL syntax: SQL functions and mathematical operators are allowed in the SELECT output list.

•Meta-data: the <Meta> tag contains all the details of the SELECT statement that retrieved the data.