Saving a views sql query
Unfortunately I wasn't able to solve this issue, so I did a little bit of a work around.

What I did was built a content type where the user could specify what data he/she needed by use of a form and fields.

I then took the user input and built a dynamic sql query to output the required data.

Its a pretty dirty way of doing it... but until I find another solution, I'll have to use it.