kysely
0.29.9 · 12 Nov 2026MIT32M / weekRepositoryHomepagenpmAtom feed
0.29.9 is the newest release of 0.27.x.
In short
3 breaking7 new2 fixed2 changed2 internal
- Breaking
intois now optional inInsertQueryNode. - Breaking
tableis now optional inUpdateQueryNode. - Breaking
Column data types are now validated at runtime. This only affects users who passed unsupported strings in the past. In case Kysely doesn't offer built-in support for a specific data type, you should have then and still should use
sqltemplate tag.
Security
3 advisories affect 0.27.3; 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 👋
This release happened on 03/09/2024.
What's Changed
Add
castmethod toExpressionBuilder.Fix bug in
ExtractTableAliasexposed by TypeScript 5.4.Add
MERGEquery support.Introspect column comments
Fix MSSQL Table Introspection Duplicate Column
Implement additional query builder clear methods
Just add missing smallint support for addColumn() (SIMPLE_COLUMN_DATA_TYPES)
Add
IDENTITYcolumn support.Add
LIMIToperator for update statementsAdd
FETCHclause support.Add
TOPclause support.
Breaking Changes
- Breaking
intois now optional inInsertQueryNode. - Breaking
tableis now optional inUpdateQueryNode. - Breaking
Column data types are now validated at runtime. This only affects users who passed unsupported strings in the past. In case Kysely doesn't offer built-in support for a specific data type, you should have then and still should use
sqltemplate tag.
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.