Has anyone created the inventory valuation summary report via suiteQL? Trying to get historical view of last 1 year for multiple locations and therefore don't want to run this 365 x 5 times... Any assistance with this please? Output would be similar to the current summary but date across the top

While it might be technically possible, recreating a historical report with SuiteQL would not be something I'd recommend attempting. I'd try to negotiate it down to a monthly frequency, and do it manually (12 x 5). To have this data for the future, you could create the report, enable Excel Web Query, and create a script to download and parse the HTML and store it to a database on a daily basis. (e.g. wiith a cron job+python script)