Persistent Temporary tables

Would be great to CREATE TEMPORARY TABLE not just session-long living, but persistent, like Oracle temporary tables. That could be used in views queries. For now I have to create regular table with connection_id() default value in column and then create editable view to mimic Oracle temporary table behavior. But this gives a headache to manage old connections data. I cannot create FK to information_schema.processlist table, so I have to build background task to delete regular table rows of non-existent connection ids.