SQL parser in C

Question

I want to parse and store the columns and values of a SQL DML (INSERT, UPDATE, DELETE) statement in C. Need the URL of the open source code or a library with which I can link my C program. The platform is SUSE Linux. Have tried to make and use libSQL unsuccessfully. A detailed answer is appreciated. Thanks.

Additional Notes: Please suggest a library/code that I can link with my C program. In my program I want to use the functions of this library to parse and use the tokens for further processing.

epatel · Answer 1 · 2009-07-18T13:14:41.380

11

You can have a look at the source code for SQLite. It uses a parser called Lemon.

Links:

SQLite architecture

Lemon parser

You can also look at the source code for postgresql-plpython3. Looks like it has a pure C based SQL parser.

Link:

postgresql-plpython3 @ github

edited Jul 18 '09 at 13:14

answered Jul 18 '09 at 11:13

epatel

45,805
17
110
144

Lemon parser! Didn't know about this. Can't wait to use it in my own project. – wheaties Jun 17 '12 at 12:02

score 5 · Answer 2 · answered Jul 19 '09 at 20:33

5

I would suggest to start from the real parser of a real DBMS. There are several in free software. For instance, the parser of PostgreSQL is in the directory src/backend/parser of the distribution and is written in C and Yacc.

answered Jul 19 '09 at 20:33

bortzmeyer

34,164
12
67
91

score 1 · Answer 3 · answered Jul 18 '09 at 10:44

1

See the Chapter "Parsing SQL" in "Lex & Yacc"(O'Reilly) in google books http://books.google.fr/books?id=YrzpxNYegEkC&lpg=PT1&dq=bison%20flex%20sql%20grammar&client=firefox-a&hl=en&pg=PA109

answered Jul 18 '09 at 10:44

Pierre

34,472
31
113
192

score 1 · Answer 4 · answered Jul 18 '09 at 11:12

1

Have you looked at SQLite ? It certainly does have the code to parse SQL, so maybe you could avoid reimplementing it..

answered Jul 18 '09 at 11:12

Andrew Y

5,107
2
28
29

score 1 · Answer 5 · answered Jul 19 '09 at 20:52

1

ANTLR can target C, among other languages, and its catalog of premade grammars has a bunch of SQL dialects - notably MySQL and Oracle.

answered Jul 19 '09 at 20:52

Pavel Minaev

99,783
25
219
289

score 1 · Answer 6 · answered Dec 06 '15 at 21:55

µSQL for C++

What is µSQL ?

µSQL is a SQL parser engine for C++ to develop SQL based applications easily, and it supports other SQL like domain specific languages such as UnQL and GQL too. Because µSQL is written only in old standard C++ library such as STL with ANTLR, then you can use it with many C++ compilers and platforms.

Repo on Github

score 1 · Answer 7 · answered Jun 04 '19 at 14:49

1

The standalone SQL parser of the Hyrise database system is open source and, even though it is written in C++, it can be accessed from C and is easy to understand and modify. It utilizes bison and flex.

answered Jun 04 '19 at 14:49

Benski

63
5

score 0 · Answer 8 · answered Jan 08 '12 at 12:02

0

Not sure is there any mature C sql parser can do that easily.

Here is a Java version SQL library can do what you need exactly, it can be used to Retrieve/Refactor table & column name from a complex SQL query easily.

answered Jan 08 '12 at 12:02

James Wang

453
4
5

You may have mentioned that this is a commercial product. – Devolus Mar 24 '20 at 07:26

score -3 · Answer 9 · answered Jul 18 '09 at 10:40

-3

Have you considered writing your own using lex and yacc? (the hacker - hardcore approach)

Not trivial .. but this site might help you get started

answered Jul 18 '09 at 10:40

lexu

8,766
5
45
63

SQL parser in C

9 Answers9

µSQL for C++

Linked