can we just extract the where condition?

[Opperessor]

is it possible to get relation between the tables using sqlglot.
eg: SELECT a.id, b.first_name, b.last_name FROM table1 a, table2 b where a.id = b.id;
output : a.id = b.id

[tobymao]

from sqlglot import parse_one, exp

sql = "SELECT a.id, b.first_name, b.last_name FROM table1 a, table2 b where a.id = b.id;"

parse_one(sql).find(exp.Where).this.sql()