Programmatically run drizzle migrations

Hey, guys!

I'm using drizzle with libsql, and due to some constraints I cannot use drizzle-kit push to run migrations.

I know some drizzle packages have the migrate function which you can use to run migrations programmatically, something lile:

import { drizzle } from 'drizzle-orm/node-postgres'
import { migrate } from 'drizzle-orm/node-postgres/migrator'
import { Pool } from 'pg'
import { Resource } from 'sst'

export const handler = async () => {
  const pool = new Pool({
    user: Resource.RDS.username,
    password: Resource.RDS.password,
    database: Resource.RDS.database,
    host: Resource.RDS.host,
    port: Resource.RDS.port,
  })

  const db = drizzle(pool)

  try {
    await migrate(db, { migrationsFolder: './migrations' })

    return {
      statusCode: 200,
      body: JSON.stringify({ message: 'Migrations completed successfully.' }),
    }
  } catch (err: any) {
    return {
      statusCode: 500,
      body: JSON.stringify({
        message: 'Migration failed.',
        error: err.message,
      }),
    }
  }
}

And I can't seem to find the migrate function on drizzle libsql package:

import { drizzle } from "drizzle-orm/libsql"

is it possible to do that with libsql?

The request concerns the drizzle-orm/libsql adapter, the migrate API, and drizzle-kit push as the current alternative. Start by checking whether the libsql adapter exposes a migrator comparable to the node-postgres example; done means establishing and documenting a supported programmatic migration path for libSQL.