Extracting all table names from a query?

[snunez1]

Does anyone have any ideas on how to extract all table names from a sxql query?

My use case involves pre-processing the tables before executing the query. I do not see any obvious way to do this, and trying to parse the sxql expression seems like a bit of work to do in a reliable way. Alternatively I could wrap the function with a macro and have the user specify the tables, but it would be nice, since the information is already there, to extract it if possible.

Any ideas?

[jackcarrozzo]

So you want a function that, when called with an sxql query, returns a list of table names in that query?

…

On Mar 25, 2022, at 10:43 PM, Steve Nunez ***@***.***> wrote:  Does anyone have any ideas on how to extract all table names from a sxql query? My use case involves pre-processing the tables before executing the query. I do not see any obvious way to do this, and trying to parse the sxql expression reliably seems like a bit of work to do in a reliable way. Alternatively I could wrap the function with a macro and have the user specify the tables, but it would be nice, since the information is already there, to extract it if possible. Any ideas? — Reply to this email directly, view it on GitHub, or unsubscribe. You are receiving this because you are subscribed to this thread.

[snunez1]

Correct.