Would be fantastic to sav SQL Query with the project.
1 - the query layer is saved with the project. (just sql and connection...) as another layer like shapefile
2 - the reload in-memory of data happens when opening the project.
3 - There a button to refresh that query when we want... (right click the layer >> refresh query)