Get 'A syntax error has occurre java.sql.SQLException: Error executing query' error viewing Data tab (4241941)

Get 'A syntax error has occurre java.sql.SQLException: Error executing query' error viewing Data tab

When viewing the Data tab, in the Object Explorer, the following error is returned.  This only happens when using a Denodo connection and when the object originated from Informix.
 
"ERROR: Error executing query.  Total time x.xxx seconds.

<TABLE_NAME> [BASE][ERROR]
<TABLE_NAME> [JDBC WRAPPER][ERROR]
<TABLE_NAME>#0 [JDBC ROUTE][ERROR] Received exception with message 'A syntax error has occurre java.sql.SQLException: Error executing query. Total time x.xxx seconds.

<TABLE_NAME> [BASE][ERROR]
<TABLE_NAME> [JDBC WRAPPER][ERROR]
<TABLE_NAME>#0 [JDBC ROUTE][ERROR] Received exception with message 'A syntax error has occurre;
Error while executing the query"

The syntax being used to limit the number of records returned in the data grid is not correct for Informix object.  Howerver, since Denodo masks what database platform the objects are from, there is no way for Toad Data Point to know what the correct syntax is.

WORKAROUND #1:
Run a SELECT query in the editor, instead, to get the data.

WORKAROUND #2:
Select Tools | Options | Database - General and check 'Unlimited' for the "Number of rows to initially fetch in data tab" option.  This will stop Toad Data Point from including the limit function in the background query used to populate the data tab.  Due to this, there will no longer be a syntax issue.  Also, all records will be fetched into the data grid.