Kysely SQL Files

Hey 👋

A small batch of bug fixes. Please report any issues. 🤞😰🤞

This maintenance release backports bug fixes and documentation improvements from the 0.29 line.

Controlled transactions get fixes for connection leaks, shared completion state, and commands racing with ongoing queries:

• Commit, rollback, and savepoint commands now wait for ongoing queries and streams to finish.
• Close or exhaust active streams before awaiting these commands.
• A failed rollback now releases the connection and marks the transaction as rolled back.

PostgreSQL and MSSQL now use session-level migration locks, including with disableTransactions: true. PostgreSQL migrations through PgBouncer transaction pooling need a direct connection, session pooling, or custom migration locking.

🚀 Features

🐞 Bugfixes

• fix: allow explicit undefined in Updateable with exactOptionalPropertyTypes. by @y-hsgw in https://github.com/kysely-org/kysely/pull/1496
• fix infinite type check recursion by @koskimas in https://github.com/kysely-org/kysely/pull/1960
• fix: release controlled transaction connection when begin fails by @igalklebanov in https://github.com/kysely-org/kysely/pull/2080
• fix: share completion state between controlled transaction handles by @igalklebanov in https://github.com/kysely-org/kysely/pull/2090
• fix: release controlled transaction connection when rollback fails by @B4nan in https://github.com/kysely-org/kysely/pull/2136
• fix: serialize controlled transaction commands with queries by @igalklebanov in https://github.com/kysely-org/kysely/pull/2081

PostgreSQL 🐘 / MSSQL 🥅

• fix: PostgreSQL and MSSQL migrations are not running exclusively when disableTransactions: true. by @morgan-coded & @igalklebanov in https://github.com/kysely-org/kysely/pull/1919

PostgreSQL 🐘 / SQLite 📘

• fix: allow immutable columns in doUpdateSet's where. by @igalklebanov in https://github.com/kysely-org/kysely/pull/2043

On-conflict WHERE predicates now use column select types, including for columns that cannot be updated.

PostgreSQL 🐘

• refactor(postgres): optimize table metadata parsing in PostgresIntrospector by @igalklebanov & @rubenferreira97 in https://github.com/kysely-org/kysely/commit/ba89cc338690f40d07f59a99a741b78a6a992f0d
• fix(postgres): release the client when destroyed while acquiring a connection by @abebelagua & @igalklebanov in https://github.com/kysely-org/kysely/pull/2088

SQLite 📘

• fix(sqlite): output RETURNING before ORDER BY and LIMIT in delete queries. by @igalklebanov in https://github.com/kysely-org/kysely/pull/1946

MSSQL 🥅

• fix(mssql): escape jsonBuildObject keys. by @igalklebanov in https://github.com/kysely-org/kysely/pull/2078
• fix(mssql): escape JSON in jsonBuildObject by @igalklebanov in https://github.com/kysely-org/kysely/pull/2079

📖 Documentation

• docs: fix PostgreSQL pool in plugin example by @igalklebanov in https://github.com/kysely-org/kysely/pull/2117
• docs: describe the LogEvent union by @igalklebanov in https://github.com/kysely-org/kysely/pull/2121
• docs: clarify shared pool and database instance lifecycles by @igalklebanov in https://github.com/kysely-org/kysely/pull/2143
• Fix typo in CreateTypeBuilder.asEnum docstring by @anonpay-sh in https://github.com/kysely-org/kysely/commit/ff15048a8f4db82b576ce93197ea7e648abfbe55

📦 CICD & Tooling

• ci: prepare 0.28.x maintenance releases by @igalklebanov in https://github.com/kysely-org/kysely/commit/5e97e1d7fb5e04d421d31b41948fd423d60e0ae8
• ci: publish maintenance releases under the release-0.28 npm tag by @igalklebanov in https://github.com/kysely-org/kysely/commit/44e7c9ae9bf1d4eb827d467ab82a5f62107410d6
• test: adapt earlier 0.29 regression tests to 0.28 APIs by @igalklebanov in https://github.com/kysely-org/kysely/commit/7d037afd322e4d7724af4962d999f61c94d1dd11

⚠️ Breaking Changes

🐤 New Contributors

What's Changed

Full Changelog: https://github.com/kysely-org/kysely/compare/v0.28.17...v0.28.18