XML.SQLExport compared to XML.Export
Contrast XML.SQLExport and 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.
•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.