Support for sqlcommenter?

[fritzblue]

Is support for sqlcommenter planned? It would be highly useful to be able to automatically attach SQL comments to correlate user code in kysely with executed SQL.

It looks like knex has support fwiw.

[igalklebanov]

Hey 👋

SQLCommenter is a suite of plugins/middlewares, have you tried requesting kysely support on their end?
I'd be more than happy to collab with them on a plugin.

[koskimas]

No answer.

[smolijar]

For anyone interested, I've been working on this for the past couple of days and it is now public. Feel free to give it a shot: kysely-sqlcommenter

import { SqlCommenterPlugin } from 'kysely-sqlcommenter'

const db = new Kysely<DB>({
  // ... kysely config
  plugins: [
    // Provide callback
    new SqlCommenterPlugin(() => asyncLocalStorage.getStore()),
  ],
})

[thelinuxlich]

hey, that's nice, I've created this PR specifically for this use case #871

[smolijar]

Hey, little update: I migrate to the new API (which is super nice, because it can now operate without monkey patching and easily across all statement types, not just SELECTs). I am running it on production now on GCP to get more of CloudSQL Insights (which is I think why most people come here).

https://github.com/smolijar/kysely-sqlcommenter