0.95.11 - 03 September, 2021

New features:

• Add support for nullability modification via schema builder (table.setNullable() and table.dropNullable()) #4657
• MySQL: Add support for mysql/mariadb-client JSON parameters in connectionURIs #4629
• MSSQL: Support comments as MS_Description properties #4632

Bug fixes:

• Fix Analytic orderBy and partitionBy to follow the SQL documentation #4602
• CLI: fix migrate:up for migrations disabling transactions #4550
• SQLite: Fix adding a column with a foreign key constraint in SQLite #4649
• MSSQL: columnInfo() support case-sensitive database collations #4633
• MSSQL: Generate valid SQL for withRecursive() #4514
• Oracle: withRecursive: omit invalid RECURSIVE keyword, include column list #4514

Improvements:

• Add .mjs migration and seed stubs #4631
• SQLite: Clean up DDL handling and move all operations to the parser-based approach #4648

0.95.10 - 20 August, 2021

Improvements:

• Use sys info function instead of connection db name #4623

Typings:

• Deferrable and withkeyName should not be in ColumnBuilder #4600

0.95.9 - 31 July, 2021

New features:

• Oracle: support specifying schema for dropTable and dropSequence #4596
• Oracle: support specifying schema for autoincrement #4594

Typings:

• Add TypeScript support for deferrable, new Primary/Unique syntax #4589

0.95.8 - 25 July, 2021

New features:

• Add deferrable support for constraint #4584
• Implement delete with join #4568
• Add DPI error codes for Oracle #4536

Bug fixes:

• Fixing PostgreSQL datetime and timestamp column created with wrong format #4578

Typings:

• Improve analytic types #4576
• MSSQL: Add trustServerCertificate option #4500

0.95.7 - 10 July, 2021

New features:

• Add ability to omit columns on an onConflict().ignore() #4557
• CLI: Log error message #4534

Typings:

• Export Knex.TransactionConfig #4498
• Include options object in count(Distinct) typings #4491
• Add types for analytic functions #4544

0.95.6 - 17 May, 2021

Typings:

• Export TransactionProvider type #4489

0.95.5 - 11 May, 2021

New features:

• SQLite: Add support for file open flags #4446
• Add .cjs extension to Seeder.js to support Node ESM #4381 #4382

Bug fixes:

• Remove peerDependencies to avoid auto-install on npm 7 #4480

Typings:

• Fix typing for increments and bigIncrements #4406
• Add typings for on JoinClause for onVal #4436
• Adding Type Definition for isTransaction #4418
• Export client class from knex namespace #4479

0.95.4 - 26 March, 2021

Typings:

• Fix mistyping of stream #4400