Expanded use of pragma changes to allow temporary tables to be written to disk for the larger SQL queries