get_all_subqueries {RSqlParser} | R Documentation |
This function takes sql statement and returns the list of subqueries.It does not return nested sub queries. For nested subqueries, each subquery needs to be fed into the method again.
get_all_subqueries(sql)
sql |
statement |
all subqueries for the sql statement
get_all_subqueries("select * from users where appid in
(select appid from applications)")