Been searching the web without success on this.
I want to store the results of a query such that I do not have to re-calculate every single time (some recalculation is permissible). The data set is large.
I have created an aggregated table based on the original data but this is of course bad practice so was investigating other potential options.
I saw SQLite allows Virtual Tables: https://www.sqlite.org/vtab.html as well as Views:https://www.sqlite.org/lang_createview.html
and was getting confused on what the difference between the two is (note: I know what a View is from having used SQL Server).