When I tested this feature, I had 30 caches per 5 minutes, and only a few from these queries had a sense. Switch between off and on is not user friendly. I believe so there can be other solution than mine, but a possibility to friendly clean unwanted caches is necessary.
If you know that you'll need the result of a query beforehand, you can always use SELECT ... INTO ... . No client-side features required.
This feature is intended for people running plenty of ad-hoc queries, when every result could potentially be useful.
