I'm very new to jOOQ and very rusty at SQL, so forgive me if I'm missing something obvious.
If I do a query returning a single record, I can easily get the single value from the row like this:
select(...).from(...).where(...).fetchOne(0, Integer.class);
But when I'm doing an insert using returning(), I don't have all those fancy featching options:
insertInto(...).values(...).returning(...).fetchOne(0, IntegerClass);
Instead I have to do:
insertInto(...).values(...).returning(...).fetchOne().getValue(0, IntegerClass);
I guess when the convenience methods were added someone forgot to add them to
InsertReturningStep.