Regex to identify table names from a field with SQ…

HI All,

My data set contains a field to store the SQL query that was execute by certain users and I would need to indentify a way to parse the SQL query text from that column and add the table values to new column in Power Query or using DAX in a Power BI report.

I am looking for regex to use and indentify table names. If there are more than 1 tables or more then it would need to concatenate them with comma.

Regex should be something like this (?:FROM|from|join|into)\s?(\[?\w+\]?\.\[?\w+\]?)”, Statement)

Please help.