Partial transaction support on NeonHTTPDialect

[kpietraszko]

While the neon() function (HTTP) doesn't support real transactions, it does support so called "non-interactive transactions" through a transaction() function.
See docs here

Do you think it would possible to support it?

As a workaround, you could add an option to pass an existing neon query object to the dialect. So the user could call neon(), pass the result to the dialect constructor, and still have access to transaction().

[igalklebanov]

Hey 👋

Kysely, as of right now, doesn't support batch requests. When it does, this'll be implemented.

For now, you can apply https://kysely.dev/docs/recipes/splitting-query-building-and-execution.