Simple experimentation with the sqlite CLI shows that SQLite converts tables created in this way into regular CREATE TABLE statements when storing the schema:
> create table lol as select 1, 2, 3;
> select name, sql from sqlite_master;
lol|CREATE TABLE lol("1", "2", "3");
So this is low priority given the present motivation of this project.
Simple experimentation with the
sqliteCLI shows that SQLite converts tables created in this way into regularCREATE TABLEstatements when storing the schema:So this is low priority given the present motivation of this project.