added generate report stubs functionality to dash
updated sql?