8 replies

Can I run the `migrate()` function exporting a raw SQL query in Drizzle ORM?

I am building a Tauri app with a local SQLite database, and I have access via JavaScript. Here's an example:

const result = await db.execute(
  "INSERT INTO todos (id, title, status) VALUES ($1, $2, $3)",
  [todos.id, todos.title, todos.status]
);

const result = await db.execute(
  "INSERT INTO todos (id, title, status) VALUES ($1, $2, $3)",
  [todos.id, todos.title, todos.status]
);

Is it possible to run migrations using Drizzle in this manner?