The SPViews software works with Windows SharePoint Server 2019, 2016, 2013, 2010 and 2007
SPViews has many uses. It is often used for integration of Data Warehouses with the SharePoint systems. Creating programs with Visual Studio for every data load is not always desired and SPViews will perform far better. It is also used for reporting within tools like Reporting Services. SPViews can also be used to streamline development of SharePoint applications. While SharePoint integration with Visual Studio is great and needed for data updates, SQL queries are easier to write against views than working with CAML.
SPViews creates views into your database. These views always display current data. You only need to run SPViews again if the list or libraries structures you are reporting on change.
You should run SPViews after any change to your list or library structure.
No. SPViews only generates a script for creating views into the SharePoint content database.