kysely
0.29.9 · 12 Nov 2026MIT32M / weekRepositoryHomepagenpmAtom feed
0.29.9 is the newest release of 0.27.x.
In short
10 new10 fixed3 changed33 internal
Security
3 advisories affect 0.27.4; 0.28.17 fixes them
- HighKysely: JSON-path traversal injection via unsanitized path-leg metacharacters in `JSONPathBuilder.key()` / `.at()`GHSA-pv5w-4p9q-p3v2 · 11 May 2026Fixed in 0.28.17
- HighKysely has a MySQL SQL Injection via Insufficient Backslash Escaping in `sql.lit(string)` usage or similar methods that append string literal values into the compiled SQL stringsGHSA-8cpq-38p9-67gx · 20 Mar 2026Fixed in 0.28.14
- HighSQL Injection via unsanitized JSON path keys when ignoring/silencing compilation errors or using `Kysely<any>`.GHSA-wmrf-hv6w-mr66 · 18 Mar 2026Fixed in 0.28.12
Release note
Hey 👋
We've reached 100 contributors AND 1,000 pull requests since our last release! 🍾
Here's all the amazing work done since version 0.27.3...
Features
Added
clearGroupBy()Add
objectStrategyoption that allows to not mutate result objects/arrays @ParseJSONResultsPlugin.
PostgreSQL 🐘 / SQLite
Support table names in UpdateQueryBuilder.returningAll
MySQL 🐬 / MS SQL Server
Add varbinary data type for mysql
PostgreSQL
Add 'add column if not exists' for postgres
Add '?|' comparison operator
Add the starts-with postgres comparison operator
Postgres introspection getTables handle partition tables as well.
MS SQL Server
Add
OUTPUTclause support.
Bugfixes
Move
preventAwaittoalter-column-builder.ts.Fixes The type of
ebinselectFrom(eb => ...)is wrongfixes QueryCompilerError: Could not serialize value causes Kysely instance to fail later
Fixes CamelCasePlugin messes up complex type mappings with setTypeParser
PostgreSQL 🐘 / MS SQL Server
Updating visitMergeQuery to join
WhenNodes with a spaceFix merge queries not being transformed.
Fix
InferResultnot working for merge queries.
MS SQL Server
Fix
MssqlDialectstreaming not handling backpressure.Fix Tedious v18 includes different TypeScript annotations
Handle connection errors @
MssqlDriver.
CICD & Tooling
Migrate to docker compose v2.
Remove docker-compose file version.
Add node22 @ tests.
Export all operation nodes, forever.
A whole project to check? Paste its package.json in the dependency check: every deprecated, outdated or vulnerable dependency, with what to upgrade to. Free, no account.