[FEATURE] Customize schema for `__drizzle_migrations` table

Running [migrate](https://orm.drizzle.team/kit-docs/overview/#running-migrations) creates a new table `drizzle.__drizzle_migrations`. This table should be created on the database we define, but instead it's always created in `drizzle` schema. Some cloud managed databases might not allow using the non-default schema.