InsertBuilder auto set returning generated keys optional

[dneves]

ps = connection.prepareStatement(query, Statement.RETURN_GENERATED_KEYS);

this code generates a 'RETURNING *' appended to the final query and this is not always the desired behavior.
for instance, i'd like to have a query like

insert into ... values ... returning id, column1, column2, ...

which can return not only the primary keys, but more columns.

Right now, i can 'force' this by setting 'returnGeneratedKeys' to false on BaseQuery, but need to cast the builder

InsertBuilder insertBuilder = InsertBuilder.into ...
Query query = insertBuilder.build();
( ( BaseQuery ) query ).setReturnGeneratedKeys( false );

Maybe it should be a setter on the InsertBuilder ?

[pr7vinas]

Hi. I might be missing something, just would like to point that, if I am not in mistake, the RETURNING keyword is PostgreSQL specific.

In my situation I am using MSSQL 2012, which uses the

 OUTPUT Inserted.<your-column>

Like in this example:

INSERT INTO table (description)
OUTPUT Inserted.myPrimaryKey VALUES ('test1'), ('test2');

I hope this can help further improvements.

Cheers.