Using PK sequences is error prone, as nothing prevents the user from accidentally specifying the wrong sequence in a call to argPkSeq. Identity columns are supported by almost all of the databases.
On the insert side, the API might be insertReturningPkDefault(columnName). For Schema, maybe have primaryKeyDefaultIdentity or just primaryKeyIdentity.
Using PK sequences is error prone, as nothing prevents the user from accidentally specifying the wrong sequence in a call to argPkSeq. Identity columns are supported by almost all of the databases.
On the insert side, the API might be
insertReturningPkDefault(columnName). For Schema, maybe haveprimaryKeyDefaultIdentityor justprimaryKeyIdentity.