MySQL 4.1 or less supports the "CREATE TEMPORARY TABLE..." syntax. MySQL 5.0+ supports the "CREATE VIEW..." syntax.
Other database engines may support the above or a completely different syntax. I would rather not write special flavors of SQL depending on which DB I'm using. Is there a way to express the use of views using HQL which will work with all DBs?

you can use views just like you use tables