SQL - Parsing a query

Question

I worked on a parser for arithmetic expressions. The key there was building a syntax tree, where leaves are variables and nodes are operators.

Not I'm thinking about parsing SQL queries. Parsing simple select won't be a problem, but I'm not pretty sure about the complex queries. Can you point me to a good reference about sql parsing. Thank you in advance!

nos · Accepted Answer · 2009-08-11 10:53:05Z

4

Take a look at the SQL BNF grammars

answered Aug 11, 2009 at 10:53

nos

231k60 gold badges436 silver badges516 bronze badges

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

Comments

Community · Accepted Answer · 2017-05-23 12:19:35Z

2

Some codesamples: Look at sourceforge Open SQL parser. There was a question for sql parser library before. Look there.

edited May 23, 2017 at 12:19

CommunityBot

11 silver badge

answered Aug 11, 2009 at 11:11

Christian13467

5,6641 gold badge33 silver badges34 bronze badges

Comments

Dan Diplo · Accepted Answer · 2009-08-11 11:17:53Z

I'm not sure if you know C# or .NET, but LinqToSql basically does this by building expression trees that are then executed only when the query is 'called'.

Collectives™ on Stack Overflow

SQL - Parsing a query

3 Answers 3

Comments

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Linked

Related