[HN Gopher] Open Source SQL Parsers
       ___________________________________________________________________
        
       Open Source SQL Parsers
        
       Author : EntICOnc
       Score  : 24 points
       Date   : 2022-04-21 08:44 UTC (14 hours ago)
        
 (HTM) web link (tokern.io)
 (TXT) w3m dump (tokern.io)
        
       | eatonphil wrote:
       | I wrote a similar post recently and not all the libraries overlap
       | interestingly. My post includes sample code for each library and
       | evaluates a few various complexity SELECT queries for
       | correctness.
       | 
       | I may have to write a second post now to include some from this
       | one that I missed!
       | 
       | https://datastation.multiprocess.io/blog/2022-04-11-sql-pars...
        
       | 1egg0myegg0 wrote:
       | Since DuckDB is so portable, it can be a good choice for adding a
       | SQL parser to a new system. Have a look here for an example that
       | uses the parser separately from the execution engine:
       | https://github.com/duckdb/duckdb/blob/master/examples/standa...
        
         | eatonphil wrote:
         | Duckdb itself uses a variation of pganalyze's library-ification
         | of postgres's parser so this seems a little indirect.
         | 
         | That said, I've heard the duckdb folks have improved on the
         | postgres parser a bit.
        
       ___________________________________________________________________
       (page generated 2022-04-21 23:00 UTC)