[FEATURE]: Option to create dynamic tables

[shadoworion]

Feature hasn't been suggested before.

• I have verified this feature I'm about to request hasn't been suggested before.

Describe the enhancement you want to request

It would be great to have an option to manage tables in the database at runtime, not just through migrations.

For example:

const tableFactory = (name: string) =>
  sqliteTable(name, {
    id: integer({ mode: "number" }).primaryKey({ autoIncrement: true }),
    ....other columns
  });

await tableFactory("some_table").createIfNotExists()

Or at least an option to generate SQL from this:

const tableFactory = (name: string) =>
  sqliteTable(name, {
    id: integer({ mode: "number" }).primaryKey({ autoIncrement: true }),
    ....other columns
  });

const sql = tableFactory("some_table").getSQL()

await db.$client.execute(sql);

[mahendradambe]

1. It would be great if we can get a feature to create an instance from existing schema (postgres) and/or table with just the schema/table name overriden?
   Along with the .getSQL(() for running the DDL.

const tenantProjectsTable = projectsTable.as({tableName: "tenant_1_projects" })

const tenantProjectsTable = projectsTable.as({schemaName: "tenant_1" })

2. For query API, this can be exposed as an ability to override the table name

db.query.projects.as({tableName: projectsTable.$.name, schemaName: projectsTable.$.schema }).findMany(...)