build(deps): bump the kysely group across 1 directory with 2 updates - #39534

Sourced from kysely's releases.

0.29.8

Hey 👋

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

PostgreSQL transactions get two fixes:

• Clients whose rollback fails are discarded instead of returned to the pool for reuse.
• Commits that PostgreSQL turns into rollbacks now throw AbortedTransactionError instead of reporting success. Controlled transactions are marked as rolled back and release their connection; a subsequent rollback().execute() safely succeeds without sending another rollback.

🚀 Features

🐞 Bugfixes

PostgreSQL 🐘

• fix(postgres): discard clients after failed rollbacks by @​igalklebanov in kysely-org/kysely#2155
• fix(postgres): reject commits that roll back aborted transactions by @​igalklebanov in kysely-org/kysely#2161

📖 Documentation

• fix(site): prevent quote grid resize loops by @​igalklebanov in kysely-org/kysely#2158
• docs(site): compare SQL query builders and ORMs by @​igalklebanov in kysely-org/kysely#2181
• docs(site): add TREK to proof wall by @​igalklebanov in kysely-org/kysely#2196
• docs(site): add Craig to proof wall by @​igalklebanov in kysely-org/kysely#2197
• docs(site): compare SQL query builders and raw SQL in TypeScript by @​igalklebanov in kysely-org/kysely#2182

📦 CICD & Tooling

⚠️ Breaking Changes

🐤 New Contributors

What's Changed

Full Changelog: kysely-org/kysely@v0.29.7...v0.29.8

0.29.7

Hey 👋

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

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.

🚀 Features

... (truncated)

• fe483ef 0.29.8
• 275b016 chore: bump dependencies. (#2209)
• f220a41 chore(deps): bump step-security/harden-runner from 2.22.1 to 2.22.3 (#2198)
• 02775e7 chore(deps): bump github/codeql-action/upload-sarif from 4.39.0 to 4.39.1 in ...
• 1dc8eba chore(deps): bump zizmorcore/zizmor-action from 0.7.1 to 0.8.0 (#2193)
• 92b2995 fix(postgres): reject commits that roll back aborted transactions (#2161)
• 22ab6fb docs(site): compare SQL query builders and raw SQL in TypeScript (#2182)
• 0127fae docs(site): add Craig to proof wall (#2197)
• 156ad36 docs(site): add TREK to proof wall (#2196)
• 361ab3d docs(site): compare SQL query builders and ORMs (#2181)
• Additional commits viewable in compare view

Sourced from kysely-codegen's releases.

0.20.0

Many great contributions, bug fixes and new features.

Resolves #284, #287, #307, #308, #72, #301, #275, #283.

defineConfig() and postprocess()

[email protected] adds a defineConfig function that makes it easy to configure kysely-codegen in a type-safe way. It also adds a new Config#postprocess function that makes it possible to process the introspected metadata before generating code. This function allows you to reuse the active kysely-codegen connection to further introspect the database and modify the metadata as needed.

Example of generating enum types from PostGraphile enum tables:

import { sql } from "kysely";
import { defineConfig } from "kysely-codegen";
import pluralize from "pluralize";
export default defineConfig({
camelCase: false,
dateParser: "timestamp",
dialect: "postgres",
excludePattern: "(graphile_migrate.|graphile_worker.private)",
outFile: "./types/database-types.ts",
postprocess: async ({ db, metadata }) => {
const rows = await db
.selectFrom("pg_catalog.pg_constraint as foreign_key_constraint")
.innerJoin(
"pg_catalog.pg_class as from_table",
"from_table.oid",
"foreign_key_constraint.conrelid",
)
.innerJoin(
"pg_catalog.pg_namespace as from_table_namespace",
"from_table_namespace.oid",
"from_table.relnamespace",
)
.innerJoin("pg_catalog.pg_attribute as from_column", (join) =>
join
.onRef("from_column.attrelid", "=", "from_table.oid")
.on(sqlfrom_column.attnum = any(foreign_key_constraint.conkey)),
)
.innerJoin(
"pg_catalog.pg_class as to_table",
"to_table.oid",
"foreign_key_constraint.confrelid",
)
.innerJoin(
"pg_catalog.pg_namespace as to_table_namespace",
"to_table_namespace.oid",
"to_table.relnamespace",
)
</tr></table>

... (truncated)

• dacb4fa chore: Fix knip issues
• 1b5d0fb chore: Ignore spellings
• e6f503e chore: Patch axios vulnerability
• 4b903f2 feat(generator): Silence dotenv tips
• 05eb580 chore: Bump version
• 3fad1b2 docs(config): Add postprocess JSDoc comment
• e394c01 feat: Add postprocess option
• ba33f98 refactor: Improve imports, ESLint config and schema types
• c010362 feat: Improve config handling
• 81cbc20 Merge branch 'master' into support-nullable-override
• Additional commits viewable in compare view