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 ...
The incorrect datatype is being generated in the changeset SQL when your DBMS is Redshift and trying to add an integer column with auto-increment enabled. The datatype SERIAL is being generated ...