Table schemas
If you declare an entity within a schema, query builder will prepend schema names in queries:
select * from schema.users
import { int, text, mysqlSchema } from "drizzle-orm/mysql-core";
export const mySchema = mysqlSchema("my_schema")
export const mySchemaUsers = mySchema.table("users", {
id: int("id").primaryKey().autoincrement(),
name: text("name"),
});