Support for kysely migration

[volnei]

I would be great if we can use kysely migrations. That should be achieved by disabling transactions

Currently we have this error

{
  error:  [VercelPostgresError: VercelPostgresError - 'kysely_transactions_not_supported': Transactions are not supported yet.] {
  code: 'kysely_transactions_not_supported',
  name: 'VercelPostgresError'
}

I think this could be useful

https://kysely-org.github.io/kysely-apidoc/interfaces/DialectAdapter.html#supportsTransactionalDdl

[volnei]

This could solve the issue

https://github.com/vercel/storage/pull/307#pullrequestreview-1575111153

[marciomunhoz]

Please help us! We need to finalize a project with this fix. 😬

[volnei]

@marciomunhoz

You can use this until vercel fixes this trivial

Object.defineProperty(
  db.getExecutor().adapter,
  'supportsTransactionalDdl',
  () => false,
)

although it is something absurdly horrible, it works.