WebGUI::DatabaseLink disallows SQL statements beginning with an open parenthesis. By preventing this through keyword detection, the following command structure is not handled by WebGUI. MySQL has no problem with it when entered directly:
(SELECT <unique criteria>) UNION (SELECT <unique criteria) ORDER BY myField;
This directly affects SQL Report query construction.