table.columns.add('id', sql.BigInt(), {nullable: false, primary: true, identity: true})

// your loop
newRow++
table.rows.add(newRow,...)

The unique solution that I found was adding a counter to my process, don't waste your time