Knex currently implements auto-incrementing columns in Oracle using a legacy approach that relies on sequences and triggers. When a user calls table.increments('id'), Knex generates two SQL statements ...

If you create a table with an auto increment and subsequently alter the name of the table knex generates a sequence trigger but doesn't correct that trigger upon rename.

The auto-increment column is a bread-and-butter feature of single-node transactional databases. It assigns a unique identifier for each row in a way that requires the least manual effort from users.