Questions tagged [general-sql-parser]

General SQL Parser is a tool for decoding sql grammer. It is available for .net, java, c/c++, VCL, and COM. It works with most major RDBMSs like Oracle, MS SQL Server, MySQL, etc.

General SQL Parser is a tool available at http://www.sqlparser.com/ for decoding sql grammer. It is available for .net, java, c/c++, VCL, and COM. It works with most major RDBMSs like Oracle, MS SQL Server, MySQL, Postgre, Sybase, Teradata and others.

3 questions
2
votes
1 answer

Extracting order type from sql parser

using global sql parser (gsp) for extracting column and sorting type from order sql query and extract and or from where condition SELECT employee_id, dept, name, age, salary FROM employee_info WHERE dept = 'Sales' and ID=1 ORDER BY salary, age…
1
vote
1 answer

How to get table names from join condition using gsqlarser?

I am trying to implement sqlparser and using gsqlparser from here. The source of the jar is in Java but I am implementing the same in Scala. Below is my query which contains a join condition. SELECT e.last_name AS name, e.commission_pct comm,…
Metadata
  • 2,127
  • 9
  • 56
  • 127
0
votes
3 answers

How to use JSQL Parser to retrieve table names from a query?

I started to write code to parse a SQL query only to find out that there are APIs available for the same. When I saw JSQLParser here, downloaded the jar using the given dependency com.github.jsqlparser
Metadata
  • 2,127
  • 9
  • 56
  • 127