new method that creates a 'CREAT VIEW' query for temporary views