Comment by hyencomper

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