db.schema.createTable('b').temporary().onCommit('drop').addColumn('foo', 'text').compile().sql
compiles to
create temporary table "b" ("foo" text) on commit drop
while
db.schema.createTable('a').temporary().onCommit('drop').as(db.selectNoFrom(sql`'foo'`.as('foo'))).compile().sql
compiles to
create temporary table "a" as select 'foo' as "foo"
version: 0.28.8