sql-parser | SQL Parser for C++ | Parser library

I am using jQuery QueryBuilder plugin. I have in operator with an input text. Users can type one value or a comma delimited string.

I used value_separator: ',' but it's taking the whole value with the surrounding spaces as you see below. The expected result should be name IN ('Alex','Anne','Marie')

I tried to use the valueSetter function as below :

Context

We're trying to built a database-application that can help first-year students prepare for their SQL-exam by assessing if a SQL-statement is a solution for the given question. The basic version simply checks if the given answer exists in the database as a known correct answer, if not it is sent to the teacher who then adds it to the database or discards it. In the next iteration we would like the application to asses answers more in the way it's done at exams, so you can still get some points even if parts of your query/statement are wrong.

Goal

To get this done we need to be able to 'break up' a statement.

For example, the answer:

My aim is to parse SQL (specifically Hive) statements with javascript, preferably Nodejs. I started out with node-sql-parser which looked promising. However I found quite a few cases where the parser did not recognize valid SQL like several nested functions on a column in a select clause, and multiple AND clauses in SQL that had lots of joins, unions, etc. (I've logged as issue but it will take some time).

I decided to look at Antlr v4. I followed the getting started steps with Hive SQL grammar. (https://github.com/apache/hive/blob/master/hplsql/src/main/antlr4/org/apache/hive/hplsql/Hplsql.g4); I generated parsers lexers and listeners using Antlr's generation for JavaSCript - all good so far. Then I tried a simple test as below:

I'm trying to create a recipe for the library here: https://github.com/hyrise/sql-parser

I'm building for OSX 10.13.

My build.sh looks like this:

I am trying to parse an sql query in nodejs using node-sql-parser.

I am trying to parse SQL string with jOOQ SQL parser. The SQL contains self defined functions like this:

I'm building a little maven application but I'm having problem with the cucumber tests. Here's the error that appears:

I tried using a custom operator but it does not seem to be working. is there any way to check null values in RSQL?

As a background, our system was working from SQL 2000 and was using the Non-ANSI syntax to write the queries. When we migrated to SQL 2008 R2, we have modified the "= * " and " * =" with RIGHT as well as LEFT joins. But now we are planning to migrate to SQL 2016. The Comma JOINs are deprecated. We can use the Comma Joins in this version also, but Microsoft suggests like this will impact the performance of the queries. Also we don't know how long SQL Server will extend the support on these Non-ANSI components.

Now we are looking for a tool (either Microsoft or Thirdparty) which can scan the stored procedures and will be able to change the Non-ANSI syntax like ',' and to replace this with INNER JOIN or JOIN.

So far I have tried with

Toad for Oracle https://www.toadworld.com/products/toad-for-oracle/f/10/t/9518

and noticed that it is not giving the proper output.

Also used couple of other tools, both of them not serving the purpose.

http://www.dpriver.com/blog/list-of-demos-illustrate-how-to-use-general-sql-parser/rewrite-oracle-propriety-joins-to-ansi-sql-compliant-joins/

http://info.swissql.com/products/sqlone-apijava/sqlone-apijava.html

It will be helpful if anybody who came across the similar scenario can shed some light on this. Any help will be much appreciated.