SOLVED!!! : Signed in as user in table and now it is executing the current user SQL Query. 

I need help with the following.

1. Getting the correct select where statement for wp tables
   my statement works in MySQL Workbench, but not in the datasource SQL query window. 
   MySQL Workbench query 
   SELECT * FROM loalistingsdb.available_listings
   Where agent_name = 'Agent's Name in MySQL DB;  

          WPDataTables SQL Query

SELECT available_listings.`title`,

       available_listings.`land_type`,
       available_listings.`street_address`,
       available_listings.`locality`,
       available_listings.`tags`,
       available_listings.`region`,
       available_listings.`zipcode`,
       available_listings.`map_url`,
       available_listings.`primary_image_url`,
       available_listings.`price`,
       available_listings.`area`,
       available_listings.`description`,
       available_listings.`agent_name`,
       available_listings.`agency_or_company_name`,
       available_listings.`agency_location`,
       available_listings.`office_phone_number`,
       available_listings.`email_address`,
       available_listings.`image_urls`
FROM available_listings
WHERE agent_name='%CURRENT_USER_FIRST_NAME% %CURRENT_USER_LAST_NAME%';

****error is Signed in user aka Agent Name ( LIMIT 10 )

  2. In my table i need the ability to add a button to each row that will allow that row item to be posted as a post to another part of my wordpress site. Is this possible? 

I had a second part of my question. Which is as follows.   

2. In my table i need the ability to add a button to each row that will allow that row item to be posted as a post to another part of my wordpress site. Is this possible? Where is the custom button functionality documentation? If I need to start another ticket for this, I can do that.