Hi Michael,

Firstly, I would like to sincerely apologize for the delayed response as we have been experiencing an unusually high number of tickets. I am sorry that it has taken longer than usual to respond to your concern and your patience is highly appreciated.

-

1. We have native integration with the 'Gravity Forms' plugin,

so if you just use our Gravity integration Add-on, you can easily use a Form as the source for Tables, so the Table can output the entries as rows, and you can also edit the Table.

Please check more here,

Before purchase you can test all the Gravity Add-on features on our sandbox site.

-

2. But if you need to pull an SQL Query from the Gravity Forms data, that is a different story.

Pulling this kind of data can only be done through a high level custom SQL Queries in our SQL based tables.

The difficulty level is higher than usual because this kind of data is stored in the database as serialized JSON format,

so a certain level of SQL skill is needed to make a custom Query.

Please be advised that writing custom SQL Queries or debugging custom Queries does not fall under what our support covers.

-

Also, our SQL Query feature is not the same as a database management tool and is not meant to be used as one, 

so for example, a Query ran through PHPMyAdmin might not work in the same way in our plugin,

since our plugin's logic is based on an SQL Parser, which has certain limitations.

Our SQL parser has full support for the SQL dialect for the following statement types

SELECT, INSERT, UPDATE, DELETE, REPLACE, RENAME, SHOW, SET, DROP, CREATE INDEX, CREATE TABLE, EXPLAIN and DESCRIBE.

Some of them are disabled for security reasons.

Filtering, sorting, and search may not work properly if you include:

• Accent graves ( ` ) around the table name
• JOIN functions
• UNION functions
• CONCAT functions
• sub-queries

The best thing you can do is,

first, try to prepare a MySQL view directly in the database (which will return the data that you need, call it e.g. “view1” and then build a wpDataTables based on a simple query like "SELECT * FROM view1″.

 If you need help with that, you can see our video, where we show an example of using View in our plugin.

-

Other than that, a good way to achieve pulling custom SQL Query data from the database can be experimenting using our WPDB SQL Query Constructor tool.

- Please note: 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 check out this official page of WP codex,  for help with writing custom Queries.

-

So to summarize, you can easily use our integration add-on if you simply need to just output the Form submissions in a Table or Edit them,

but if you need an actual SQL Query and to make an SQL Table from that in our Plugin, that is very complex and is not covered by our Support - you can only try with Custom Queries.

Let me know if you have any additional questions.