In the Using the Mozilla SQL Parser — Part 1 article on Mozilla SQL Parser, we covered how the moz-sql-parser package can be used to parse an SQL Select statement into a JSONified structure. In this part, we will cover how to extract names of the tables mentioned in the ‘from’ clause of the query.

The SQL we are using is

SELECT s_name from student where s_id in2
(select s_id from student_course where c_id in3
(select c_id from course where c_name = 'DSA'4
and c_name = 'dbms' or c_name = 'algorithm'));

To parse this query, we use

parsed_query = parse(query)

where, parse is a method provided by the moz_sql_parser.

After parsing, the module generates a JSONified structure, as given below.

JSON

#python #sql