search

Samagra-Development / Text2SQL

20 stars 11 forks source link

SQL parser requirement #43

Open ShubhamBhut opened 1 year ago

ShubhamBhut commented 1 year ago

Currently db_helper.py is using manual parsing with regex. Which seems unable to handle a set of queries properly like -

  1. CTEs using semicolon
  2. when semicolon or double dash are inside the string who is part of SQL query

The most optimal solution seems to use a sql parser module for this as they can handle complex SQL queries and avoid errors.