Query as table column to join tables

I created a table for a list using the swpm members table to show members list on a page (using the table shortcut) One column in the table shows the membership_level which is the ID of the row in another table – the swpm membership table. I want to show the alias (a value in the swpm membership table) from the membership table not the id.
I see indications this is possible even without the premium version of wp-data using a saved query in a column of the table – or perhaps another method. However your documentation is just too confusing and I cannot even get started after several hours of searching and trying.

First question. Is this possible without the premium version?
Second question: If possible, where is a simple example or can you show me how.

I have done this in many different websites but not with WP and not with the wp-data plug in. for instance by joining tables then showing the values I want in the list (report/wp-data table). For instance
‘Members’ table column ‘membership id’ –>join-> membership table id -to–> alias ( the name of the membership level)

Can you give me some examples of how do do that using wp-data
Thanks.