Packages

kysely

0.29.9 · 12 Nov 2026MIT32M / weekRepositoryHomepagenpmAtom feed

Your version

0.27.4

5 Jul 2024Where it was published

0.29.9 is the newest release of 0.27.x.

In short

10 new10 fixed3 changed33 internal

Security

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 objectStrategy option 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 OUTPUT clause support.

Bugfixes

  • Move preventAwait to alter-column-builder.ts.

  • Fixes The type of eb in selectFrom(eb => ...) is wrong

  • fixes 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 space

  • Fix merge queries not being transformed.

  • Fix InferResult not working for merge queries.

MS SQL Server

  • Fix MssqlDialect streaming 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.