Hi, Steve 

Sorry for the delay.

- I am not 100% sure i understood the use-case.

Could you elaborate a bit, when you say to include a column for the featured image,

do you mean to for example, merge several cells in this column for the image to take the entire space, while possibly having other rows in other cells?

If you could maybe show us any working example with a screenshot, or you could just confirm that for us,

to be sure we understand what is the goal.

If you wish to merge cells, you will only be able to do this with a Simple Table.

It is not possible for any other table type at the moment.

-

I just made a small example, with my Simple Table.

I can merge several cells in this column, then i expand the width a bit to have a larger image,

then i go to the "insert media" button, and i can choose the image from WP Media Library.

This is how it looks on the front-end :

Let me know if that is the goal, or perhaps you need something different?

Thank you

Hi, Steve.

As far as i am aware, all the images are stored in the WordPress Media Library, but i am not 100% sure about featured images.

We will check this with our 2nd level and we will advise if what you need is possible.

Thank you

Hi, Steve.

Apology for all the waiting time.

I double-checked this with our senior 2nd level Team, they helped me confirm everything.

You are correct. If we just try to use our SQL Query helper Tool,  

we can not choose a column there in order to provide featured images in this way.

Images are stored in the database tables as links/path to the image,

so if you wish to show featured images in a column, 

you can use SQL CONCAT function with our plugin's SQL Query-based tables, 

for example, you would add a CONCAT column to the Query, it would be something like this :

CONCAT ('<img src="',table.column,'" height="40">') AS image_column

( * instead of this part " table.column"  you would input your database table name, and column name which holds the image you need.)

You can learn more about how SQL CONCAT works here https://www.w3schools.com/sql/func_mysql_concat.asp

And here we have a Video tutorial example how it is used with our plugin.

Please note: Using this plugin feature requires at least a basic knowledge of SQL. It is assumed that you can create the table in some MySQL data manager (e.g., PHPMyAdmin, MySQL Workbench), and prepare a SQL query that will return the data you need. 

A good way to achieve this 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.

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

You can check out this official page of WP codex,  for help with writing custom Queries.

We hope this helps.

Hi, Steve.

Apologies, that was a misunderstanding from our end.

Thank you for this clarification, now i see what you meant.

You are correct.  Basically, there is no predefined column in the database that could simply be selected with our SQL Query Constructor/helper tool in a user-friendly way.

Yes.  The CONCAT would be useful for a specific use-case when we wish to have a thumbnail version of the image passed with the full version in same cell, but that is another subject.

Let us know if we can assist further or if you have any additional question about this.

Thank you.