ggoksu@redhat.com asked if there was possibility to add query hint for Oracle during inserts

INSERT /*+ append */  INTO dbname.tablename. 

As how now we don't support it.

ccranfor@redhat.com repoterd 

In fact a quick search for append-only inserts for databases beyond Oracle like SQL Server and Db2 seem to have equivalents; however this isn't universal.  For example Oracle applies this as a hint on the insert where-as for SQL Server and Db2 this is handled via DDL clauses, part of CREATE TABLE for SQL Server and ALTER TABLE for Db2.

So the suggestion is to 

Create a new insert.mode called append_only.  Then for each database dialect it would handle this as needed or if not supported, we could either

(a) fall back to insert or

(b) simply throw a configuration error.