parser

A MySQL Compatible SQL Parser (by pingcap)

Parser Alternatives

Similar projects and alternatives to parser

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better parser alternative or higher similarity.

parser reviews and mentions

Posts with mentions or reviews of parser. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-05-17.
  • sqlc: Generating go code from sql statements
    4 projects | /r/golang | 17 May 2022
    For MySQL the situation is a bit different. sqlc uses the parser of TiDB (https://github.com/pingcap/parser), which is a parser that aims to be basically compatible with MySQL, but is quite young and is not a MySQL parser. The most basic queries work, but even simple joins or aggregations usually result in variables with unknown data types or wrong nullability. So you loose a lot of the benefits of sqlc. Manual type annotations for MySQL also do not work most of the time. They are simply ignored and forwarded to MySQL as invalid query if they do not occur on a place where sqlc is expecting them.
  • Wp-SQLite: WordPress running on an SQLite database
    9 projects | news.ycombinator.com | 16 May 2022
    This is a disaster waiting to happen. Regular expressions should never be used to parse non-regular languages, of which SQL is one.

    There are a variety of mature MySQL dialect parsers available[1][2], and MySQL should have its own public APIs for transforming a query into an AST. Any of those would be a safer and more correct alternative.

    [1]: https://github.com/pingcap/parser

    [2]: https://github.com/square/mysql-parser

  • Open Source SQL Parsers
    17 projects | dev.to | 8 Oct 2021
    Pingcap parser is a MySQL parser in Go.
  • A note from our sponsor - LearnThisRepo.com
    learnthisrepo.com | 26 Feb 2024
    LearnThisRepo lets you learn 300+ open source repos including Postgres, Langchain, VS Code, and more by chatting with them using AI! Learn more →

Stats

Basic parser repo stats
3
1,381
3.2
3 months ago
Learn 300+ open source libraries for free using AI.
LearnThisRepo lets you learn 300+ open source repos including Postgres, Langchain, VS Code, and more by chatting with them using AI!
learnthisrepo.com