> However, since the general "idea" behind jOOQ seems to be that
> anything that is "valid" in SQL is valid in jOOQ, i doubt wether this
> is something that should be imposed by jOOQ? What about legacy
> databases that cannot be changed?
UpdatableRecord.store() is not really "SQL". I'd rather consider that
a little functionality subset of what other ORM's (or ActiveRecords)
do.
However, you can always do this:
create
.update(LEDGER)
.set(CODE, 'new-code')
.where(CODE.equal('old-code'))
.execute();
That's perfectly fine with jOOQ.
