For cases like these, I use sql views - CREATE VIEW view as SELECT * .. Then DROP VIEW view.