Hello John

Thank you for your interest in wpDataTables.

If you know your way around SQL, there are only few limitations that could get in the way. You can pull all the data you have stored in your database and create tables from it.

We even have a helper - wpDataTables query constructor, but this tool is not an ultimate query generator. It simply constructs a suggestion of a query. We are constantly working to improve it, but SQL is such a complicated and flexible language that full automation for constructing queries is next to impossible. Consequently, the more complicated the query, the higher is the probability that it will not return exactly what you need. So, you will often need to play around with the resulting query.

You can test the full plugin on our sandbox site, where you can even connect your database as a separate DB connection, and see what the plugin can do.

If you have any further questions, please feel free to ask.

Hello John

Mostly - yes. However, when it comes to editing, you need to know that tables that have JOINs, CONCATs, UNIONs and other similar statements cannot be properly edited, and are mostly used for displaying data.

Report Builder is a paid add-on which pulls the data from your existing tables and (depending on the used template) displays a report from the data in the table, yes.