Find syntax error IN SQL query using python

Question

I want to parse sql file using python code and find any syntatical error present in the file. Is there any way to do it?

Toby Mao · Accepted Answer · 2022-04-30 05:52:57Z

2

import sqlglot
sqlglot.parse_one("select (")
>> sqlglot.errors.ParseError: Expecting ). Line 1, Col: 8.

select (

answered Apr 30, 2022 at 5:52

Toby Mao

5944 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1