What are the limitations on reverse engineering SQL statements to Query Builder?
The Query Builder supports the reverse engineering of queries. Although it was heavily tested throughout its development lifecycle, due to the vast array of possible queries there may be some queries it can create but cannot reverse. Please contact the Toad development team if you discover any such queries at ToadforOracle.com. The main limitations of reverse engineering are that it only supports single-level subqueries in the SELECT and WHERE nodes, and no subqueries in the FROM clause, and some calculated fields that include arithmetic operators might not be reversed correctly.
More more information, please refer to the Toad Help File.