get_all_subqueries {RSqlParser}

Get the subqueries in sql statement

Description

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.

Usage

get_all_subqueries(sql)

Arguments

sql

statement

Value

all subqueries for the sql statement

Examples

get_all_subqueries("select * from users where appid in
  (select appid from applications)")