0.95.11

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

Improvements:

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

Typings:

• Deferrable and withkeyName should not be in ColumnBuilder #4600
• Add TypeScript support for deferrable, new Primary/Unique syntax #4589

New features:

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

0.95.8

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.5

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.3

New features:

• PostgreSQL: Add "same" as operator #4372
• MSSQL: Improve an estimate of the max comment length #4362
• Throw an error if negative offset is provided #4361

Bug fixes:

• Fix timeout method #4324
• SQLite: prevent dropForeign from being silently ignored #4376

Typings:

• Allow config.client to be non-client instance #4367
• Add dropForeign arg type for single column #4363
• Update typings for TypePreservingAggregation and stream #4377

0.95.2

0.95.2 - 11 March, 2021

New features:

• Improve ESM import support #4350

Bug fixes:

• CLI: update ts.stub files to new TypeScript namespace #4344
• CLI: fix TypeScript migration stub after 0.95.0 changes #4366

Typings:

• Move QueryBuilder and KnexTimeoutError into knex namespace #4358

Test / internal changes:

• Unify db test helpers #4356

0.95.1 - 04 March, 2021

Bug fixes:

• CLI: fix knex init not finding default knexfile #4339

0.95.0

0.95.0 - 03 March, 2021

Please upgrade to TypeScript 4.1 if using an older version!
Check out the migration guide for other breaking changes.

New features:

• Add transaction isolation support #4185
• Add analytic functions #4188
• Change default to not trigger a promise rejection for transactions with a specified handler #4195
• Make toSQL().toNative() work for Raw to match the API for QueryBuilder #4058
• Allow 'match' operator #3569
• Support optimizer hints #4243
• Add parameter to prevent autoincrement columns from being primary keys #4266
• Make "first" and "pluck" mutually exclusive #4280
• Added merge strategy to allow selecting columns to upsert. #4252
• Throw error if the array passed to insert is empty #4289
• Events: introduce queryContext on query-error #4301
• CLI: Use UTC timestamp for new migrations #4245
• MSSQL: Replace MSSQL dialect with Tedious.js implementation #2857 #4281
• MSSQL: Use "nvarchar(max)" for ".json()" #4278
• MSSQL: Schema builder - add predictable constraint names for default values #4319
• MSSQL: Schema builder - attempt to drop default constraints when changing default value on columns #4321
• SQLite: Fallback to json for sqlite3 when using jsonb #4186
• SQLite: Return complete list of DDL commands for creating foreign keys #4194
• SQLite: Support dropping composite foreign keys #4202
• SQLite: Recreate indices when altering a table #4277
• SQLite: Add support for altering columns #4322

Bug fixes:

• Fix issue with .withSchema usage with joins on a subquery #4267
• Fix issue with schema usage with FROM clause contain QueryBuilder, function or Raw #4268
• CLI: Address raised security warnings by dropping liftoff #4122
• CLI: Fix an issue with npm@7 and ESM when type was set to 'module' in package.json #4295
• PostgreSQL: Add check to only create native enum once #3658
• SQLite: Fix foreign key "on delete" when altering a table #4225
• SQLite: Made the constraint detection case-insensitive #4330
• MySQL: Keep auto increment after rename #4266
• MSSQL: don't raise query-error twice #4314
• MSSQL: Alter column must have its own query #4317

Typings:

• Add missing onConflict overrides #4182
• Introduce the "infamous triplet" export #4181
• Fix type definition of Transaction #4172
• Add typedefinitions for havingNotIn #4265
• Include 'name' property in MigratorConfig #4300
• Improve join and conflict types #4318
• Fix ArrayIfAlready type #4331

Test / internal changes:

• Drop global Knex.raw #4180
• Stop using legacy url.parse API #3702
• Various internal refactorings #4175 #4177 #4178 #4192
• Refactor to classes #4190 #4191 #4193 #4210 #4253
• Move transaction type tests to TSD #4208
• Clean up destroy logic #4248
• Colorize code snippets in readme files #4234
• Add "Ecosystem" documentation for Knex plugins #4183
• Documentation cleanup
• SQLite: Use SQLite "rename column" instead of a DDL helper #4200
• SQLite: Simplify reinsert logic when altering a table #4272

0.21.17

0.21.17 - 30 January, 2021

Bug fixes:

• SQLite: Fix SQLite foreign on delete when altering a table #4261

New features:

• Add support for optimizer hints (see knex/documentation#306 for documentation) #4243

0.21.16 - 17 January, 2021

Bug fixes:

• MSSQL: Avoid passing unsupported pool param. Fixes node-mssql 7+ support #4236

0.21.15

Prepare 0.21.15 for release

0.21.14

Prepare 0.21.14 for release