knex 3.2.0 on Node.js Yarn

What's Changed

Add migration lifecycle hooks by @timorthi in #5541
Move website by @rluvaton in #5792
fix docs deployment by @rluvaton in #5870
trigger change in docs folder for website deployment by @rluvaton in #6029
fix docs edit branch link and trigger website deployment on workflow changes as well by @rluvaton in #6030
update publish directory by @rluvaton in #6031
Fix whereILike issue with sqlite (#5604) by @mohammedbalila in #5687
fix: recover from broken connection by @beltschatsar in #5774
Run CI on Node 22 and remove dtslint by @kibertoad in #6165
Specify behavior of first on 0 matches by @WebFreak001 in #6164
fix: Fix The operator "<=>" is not permitted in MySQL by @AdrienPoupa in #6158
update upsert documentation with support in MySQL by @voda in #6150
Import knex as type in TS seed template by @OliverWales in #6094
Pin MySQL version in Docker by @kibertoad in #6166
query-builder.md fix section title by @luckv in #6180
fix: add @types/minimatch to fix TypeScript build by @mercmobily in #6240
Update ESLint rules to allow modern syntax supported by knex's minimum node version by @myndzi in #6318
Fix test:cli tests by @myndzi in #6310
Fix various failing tests by @myndzi in #6313
Ensure CRDB has the expected database before running integration tests by @myndzi in #6311
Fix migration CLI and cli tests by @myndzi in #6264
Fix where in query with raw column by @myndzi in #6323
Update to non-screamy versions of dependencies that have npm audit failures by @myndzi in #6324
fix(docs): mark function as code by @janpio in #6019
add MariaDB to README by @robertsilen in #6120
Fix links to documentation in README.md by @DavidBruant in #6055
fix link to pg-query-stream by @VincentHardouin in #6121
New, vastly improved web site by @mercmobily in #6332
Fix VitePress build in CI (WebCrypto) by @mercmobily in #6339
Fix the TypeScript example code. by @n0x001 in #6191
docs: formulated behavior of knex.transaction more explicitly by @0x0dd4b2 in #6244
Types no longer allow knex to be called without tablename by @jpike88 in #6188
added missing methods to schema-builder.md by @miguelfriasd in #6177
fix: Update documentation for conflict to include table alias by @jsk95 in #6020
fix pluck typing issue when CompositeTableType is used by @aq1018 in #4609
add additional typing for column.index by @1mike12 in #5371
Add Type Definition for orderBy with Raw Expression Issue 5711 by @redaxle in #5803
Update typings for increment/decrement by @SDemonUA in #5674
Prevent unexpected combinations of statements and clauses groups from executing by @myndzi in #6314
Refactor SQLite transactions to allow setting the foreign_keys pragma for a transaction by @myndzi in #6315
Improve CLI error reporting in some edge cases by @myndzi in #6265
Fix ESM export and typings by @patrickshipe in #6227
Feat: Support defaultSafeIntegers option in better-sqlite3 dialect by @dong-jun-shin in #6320
Fixes light mode. Fixes #6341 by @mercmobily in #6345
Update index.d.ts by @hzgotb in #5767
Website: real snippets for schema building too (!) by @mercmobily in #6343
Added sqlite to allow site generation for DDL by @mercmobily in #6349
Remove update_gitignore_for_tsc_output script by @myndzi in #6355
feat(postgres): default datetime/timestamp precision setting added by @fabis94 in #5311
fix: migrate up with completed migration by @hailerity in #6342
Feat: improve safeIntegers support for better-sqlite3 by @dong-jun-shin in #6352
chore(types): use syntax import from instead of import = require() by @waitingsong in #5258
[TypeScript] Fix usage of object type that is too broad. by @VanTanev in #5373
Optimize stream.write in mssql by @Connormiha in #5693
Apply formatting - fix lint error from a stray file in master by @myndzi in #6357
More complete queries for sqlite in documentation by @mercmobily in #6350
Add 'validate' pool options. Resolves #5119. by @rektide in #5120
feat: add dropUniqueIfExists by @louispotok in #6069
Fixed error in documentation due to wrong conflict resolution by @mercmobily in #6365
DRI assignment logic in workflow by @mercmobily in #6326
add SIMILAR TO operator by @rachelleannmorales in #5303
chore: remove deprecated docker-compose version by @lraveri in #6370
Add SVG logo and multi-format favicons by @mercmobily in #6373
Enable OIDC-based version publishing workflow by @kibertoad in #6344
Postgres: clearer error when pg-query-stream is missing by @lraveri in #6362
docs: fix typo in migrations.md by @Moha2088 in #6280
Enable commit of version bump and tag push in publish workflow by @myndzi in #6375
Add links to issue references in changelog by @myndzi in #6340
Additional tests for JSON (de)serialization by @kibertoad in #4451
Fix the artifact dirty check by @myndzi in #6382
Fix CI by addressing incompatibilities by @kibertoad in #6396
Update changelog by @kibertoad in #6395

New Contributors

@rluvaton made their first contribution in #5792
@mohammedbalila made their first contribution in #5687
@beltschatsar made their first contribution in #5774
@WebFreak001 made their first contribution in #6164
@AdrienPoupa made their first contribution in #6158
@voda made their first contribution in #6150
@luckv made their first contribution in #6180
@mercmobily made their first contribution in #6240
@janpio made their first contribution in #6019
@robertsilen made their first contribution in #6120
@DavidBruant made their first contribution in #6055
@VincentHardouin made their first contribution in #6121
@n0x001 made their first contribution in #6191
@0x0dd4b2 made their first contribution in #6244
@miguelfriasd made their first contribution in #6177
@jsk95 made their first contribution in #6020
@aq1018 made their first contribution in #4609
@1mike12 made their first contribution in #5371
@redaxle made their first contribution in #5803
@SDemonUA made their first contribution in #5674
@dong-jun-shin made their first contribution in #6320
@hzgotb made their first contribution in #5767
@fabis94 made their first contribution in #5311
@hailerity made their first contribution in #6342
@waitingsong made their first contribution in #5258
@VanTanev made their first contribution in #5373
@Connormiha made their first contribution in #5693
@rektide made their first contribution in #5120
@louispotok made their first contribution in #6069
@rachelleannmorales made their first contribution in #5303
@lraveri made their first contribution in #6370
@Moha2088 made their first contribution in #6280

Full Changelog: 3.1.0...3.2.0