The implementation to support this feature is done and checked into 13.0 branch as SVN r33431/13.0.3-14.  This implementation supports both AQResultSet and AQDataSet.

When I tried to merge SVN r33431 back to 14.0 branch, I found that CoreDataSet has been modified and the method that is used to convert a AQResultSet to a AQDataSet has been removed in 14.0 branch; hence, SVN r33431 won't compile in 14.0 branch.

The method that is used to convert an AQResultSet to an AQDataSet is CoreDataSet(CoreAqua, AQDataReader) which is removed by SVN r31419 checked in on 2/21/13 by KH. The comment of SVN r31419 is "Move open API core data and pivot data implementation from aqua-open to aqua-external". If SVN r31419 is to move packages around, why it removed CoreDataSet(CoreAqua, AQDataReader) and methods called from this constructor. Anyone knows the reason? I will check with Niels tomorrow morning.

If CoreDataSet(CoreAqua, AQDataReader) is no longer supported, I need to review OPEN API to see how I can convert an AQResultSet to an AQDataSet; otherwise, I need to modify newly implemented code and drop support for AQResultSet.

>> If CoreDataSet(CoreAqua, AQDataReader) is no longer supported, I need to review OPEN API to see how I can convert an AQResultSet to an AQDataSet; otherwise, I need to modify newly implemented code and drop support for AQResultSet.

OK, no problem.  CoreDataSet(CoreAqua, AQDataReader) related codes have been moved to its base class. I just need to add CoreDataSet(CoreAqua, AQDataReader) back.

14.0 branch - SVN r33432/14.0.0-beta-78

Two new interfaces are added to support this feature: AQResultComparator and AQResultDifferences. Please see javadoc for more info.
   13.0  - SVN r33431/13.0.3-14.
   14.0  - SVN r33432/14.0.0-beta-78
   trunk - SVN r33433/15.0.0-dev-6

An example script is attached to demonstrate how to use newly added APIs. The screenshot of HTML generated by the example script is also attached, the generated HTML is tested on the following browsers:
   Chrome: Version 28.0.1500.95 m
   FireFox: 22.0
   IE: Version: 8.0.6001.18702

A screenshot contains modified cells also attached FYI, this screenshot is generated by the unit test script.

Note: in this initial implementation:
* No formatting support on Number and Date objects.
* No custom font/font-size support when writing output to file in HTML.

o One change: the saveToHtml should attempt to create the directory structure using the mkdirs() call. This is what our SchemaDifferences object does

o One question: the order in which the result sets are displayed is different than when the resultset compare is run via the UI. Lets discuss why...

In the html file, after specifying:

Results Compare for

Left Side...

Right Side...

add: 

Primary Keys: x, y, z

was curious if we're going to add a color key to this so that people understand what green, red and blue mean.

see this comment on IID 1868
 

>> One question: the order in which the result sets are displayed is different than when the resultset compare is run via the UI. Lets discuss why...

If you compare the orders of results set generated by the original SELECT statement and the order of results sets displayed by ADS' results compare, you will see they are out of sync.  I believe the order of result sets displayed by open API is the same as the order of the result sets displayed by the original SELECT statement.

(1) Added primary key list to HTML output.
(2) Added legend to HTML output.
(3) Created HTML output folders if they don't exist.
   13.0  - SVN r33455/13.0.3-15
   14.0  - SVN r33456/14.0.0-beta-79
   trunk - SVN r33457/15.0.0-dev-6
See updated screenshots for more info.

(1) Removed AQResultDifferences.saveToHtml(String fileName, boolean append) API.
(2) Added current database and schema to default label if they are not blank.
   13.0  - SVN r33490/13.0.3-18
   14.0  - SVN r33492/14.0.0-beta-80
   trunk - SVN r33494/15.0.0-dev-6
See DefaultLabel screenshot for details.