[lgas]

Doesn't the offset approach run into trouble when sequence values get skipped due to rollbacks?

[staticassertion]

It's going to be an optimization that assumes some constraints on how you interact with your database.