This can be used to add any additional SQL to the front of the query after the create keyword.

Also see {@link temporary}.

Examples

db.schema.createTable('person')
  .modifyFront(sql`global temporary`)
  .addColumn('id', 'integer', col => col.primaryKey())
  .addColumn('first_name', 'varchar(64)', col => col.notNull())
  .addColumn('last_name', 'varchar(64), col => col.notNull())
  .execute()

The generated SQL (Postgres):

create global temporary table "person" (
  "id" integer primary key,
  "first_name" varchar(64) not null,
  "last_name" varchar(64) not null
)