Support temporary tables

[federico-razzoli]

Support the syntax:

CREATE TEMPORARY TABLE t ( ... );

These tables only exist in the current session.

[federico-razzoli]

If we drop a temporary table, while not mandatory, it is much safer to use this syntax:

DROP TEMPORARY TABLE t;

The reason is that some DBMSs (and probably SQL standard) allow to create a temp table with the same name of a regular table. The temporary table will shadow the other. But if it disappears (maybe because you disconnect and reconnect), DROP TABLE would kill the regular table...

[federico-razzoli]

If task #16 is implemented, in PosgreSQL it would be nice to implement this SQL syntax:

ON COMMIT [ PRESERVE ROWS | DELETE ROWS | DROP ]

[FCO]

Now this is possible:

$ perl6 -Ilib -MRed -e '

model Bla is temp { has Int $.a is column }

my $*RED-DB = database "SQLite";

my $*RED-DEBUG = True;

Bla.^create-table;
'
SQL : CREATE TEMPORARY TABLE bla(
   a integer NOT NULL 
)
BIND: []

@Santec Could you please confirm if we can close this issue please?