You can use :memory as a filename for SQLite and that's just what it'll do. Of course if it's in your OSs filesystem cache then it is in memory even if it's on disk.

Or you can roll your own and write your own query language too...