Yes, temp storage is another 'use case' for me too. On one particular web app I designed, there is a requirement for searching across multiple tables for text

Yes, temp storage is another 'use case' for me too. On one particular web app I designed, there is a requirement for searching across multiple tables for text data. I simply transpose the columns I need from the different tables into a memory SQLite database 'on the fly' and perform a full text search on that for lightning quick responses and no need to do multi table joins.