How to generate "CREATE TABLE" SQL from pgTable definition?

[codeBelt]

I want to automatically generate the CREATE TABLE IF NOT EXISTS SQL string directly from the pgTable schema definition in Drizzle ORM. This would allow me to pass the generated SQL to an in-memory database for testing purposes.

Currently, I'm manually constructing the SQL string like this:

await inMemoryDbClient.exec(`
  CREATE TABLE IF NOT EXISTS "email_submission" (
    "id" serial PRIMARY KEY NOT NULL,
    "name" text NOT NULL,
    "email" text NOT NULL,
    "created_at" timestamp DEFAULT now() NOT NULL,
    CONSTRAINT "email_submission_email_unique" UNIQUE("email")
  );
`);

However, I'd like to automate this process directly from the pgTable schema, which looks like this:

import {lower} from '@/drizzle/db.utils';
import {pgTable, serial, text, timestamp, uniqueIndex} from 'drizzle-orm/pg-core';

export const emailSubmissionTable = pgTable(
  'email_submission',
  {
    id: serial('id').primaryKey(),
    name: text('name').notNull(),
    email: text('email').notNull().unique(),
    createdAt: timestamp('created_at').notNull().defaultNow(),
  },
  (table) => [uniqueIndex('unique_email_idx').on(lower(table.email))]
);

I am using diffTestSchemas to generate the SQL manually, but this is not convenient for testing, as I need to execute the SQL string dynamically in my in-memory database.

const to = {emailSubmissionTable};

const { sqlStatements, statements } = await diffTestSchemas({}, to, []);

console.log(sqlStatements);
/* Output:
[
  'CREATE TABLE "emailSubmission" (\n' +
    '\t"id" serial PRIMARY KEY NOT NULL,\n' +
    '\t"name" text NOT NULL,\n' +
    '\t"email" text NOT NULL,\n' +
    '\t"createdAt" timestamp DEFAULT now() NOT NULL,\n' +
    '\tCONSTRAINT "emailSubmission_email_unique" UNIQUE("email")\n' +
    ');\n',
  'CREATE UNIQUE INDEX "emailUniqueIndex" ON "emailSubmission" USING btree ("email");'
]
*/

What I Need:
It would be great if Drizzle ORM provided a built-in helper function to generate the CREATE TABLE IF NOT EXISTS SQL string directly from the pgTable schema definition, like this:

import {generateCreateTablesSQL} from 'drizzle-orm/utils'; // Hypothetical helper function

const inMemoryDbClient = new PGlite();

// Generate the SQL string from the pgTable schema
const sql = generateCreateTablesSQL(emailSubmissionTable);

// Execute the generated SQL in the in-memory database
await inMemoryDbClient.exec(sql);

This would save time and simplify the process of testing queries against an in-memory database.