Support for CREATE TABLE table AS select_statement?

[AlexErrant]

I think this is a feature request, but does Kysely support creating a new (potentially temporary) table from a select statement?

This feature seems to be supported by the major databases; MySQL, PostGres, Sqlite.

[koskimas]

Sounds like a good addition 👍. Let's add it.

The API would be:

db.schema
  .createTable('new_table')
  .as(db.selectFrom('person').select(['id', 'first_name']))

The function signature:

as(expr: Expression<unknown>) {
  ...
}

Temporary tables are already supported. You'd just use:

db.schema
  .createTable('new_table')
  .temporary()
  .as(db.selectFrom('person').select(['id', 'first_name']))

[LeoOmori]

hi, can i try to work on this?

[igalklebanov]

@LeoOmori Go ahead, good luck! If you have any question, feel free to post in the contribution channel on discord.

[viraxslot]

Hi all, there's no activity since september so I'd like to work on this issue.
@LeoOmori please ping me if you started to implement something and I have to stop :)