Create a plugin with a backend report/table generator. This will have a temp Admin menu and inside that menu will have a Tables menu and a Add new menu.
In the Tables menu, it will show a table with all the features as any WordPress table (Search, inline checkbox, Bulk Action, different Filters, etc). The table will show these columns:
The Add new form will show the user with a two side/columns form. The left side will be for entering the report/table data plus the SQL script for the table and the right side for a preview of the table. The table will be using [login to view URL]
In the frontend where the shortcode will be used to present the tables, they must have the searchbox an export button to csv, xlsx, pdf and print.
The table in the database that will hold the reports will have these columns
• id number
• name string
• slug string
• shortcode string
• SQLscript string