[DOCS]: Add config parameter example for `migrate` function

[xqm32]

Several docs currently show migrate(db) without the required config parameter, which can confuse developers. As of now, the migrate function needs a config object, for example:

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

The option is missing in main docs such as:

• src/content/docs/migrations.mdx

Please update the relevant sections to include the config usage and make it clear this parameter is necessary.

---

Submitted with the assistance of AI.

[AiAlchemist0]

Opened #708 — migrate(db, { migrationsFolder: './drizzle' }) on the dialect migrations pages.