JSqlParser

JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern (by JSQLParser)

JSqlParser Alternatives

Similar projects and alternatives to JSqlParser

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

JSqlParser reviews and mentions

Posts with mentions or reviews of JSqlParser. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2022-07-29.
  • Semantic Diff for SQL
    7 projects | news.ycombinator.com | 29 Jul 2022
    I wonder if this is a topical thread to check if anyone is aware of a Java based solution to parse a CREATE VIEW statement to get a mapping between the view columns and the corresponding source table columns. I checked out jsqlparser[0] and it does produce an AST which can be parsed using the visitor-pattern[1] but was wondering if there is a more "out-of-the-box" solution. Due to various reasons, querying the database information schema is not an option I can pursue.

    [0]: https://github.com/JSQLParser/JSqlParser

    [1]: https://en.wikipedia.org/wiki/Visitor_pattern

  • Open Source SQL Parsers
    17 projects | dev.to | 8 Oct 2021
    JSQLParser can parse multiple SQL dialects like MySQL, Postgres and Oracle. The grammar can be modified to support other SQL dialects.
  • Let's write a compiler, part 5: A code generator
    14 projects | news.ycombinator.com | 19 Aug 2021
  • Racket v8.0
    7 projects | news.ycombinator.com | 14 Feb 2021
    Interesting coincidence - I'm working on a parser that parses the AST produced by JSqlParser[0] for a create view statement to generate mapping between the columns of a view and the columns of its underlying table. It is an interesting example of having to use the visitor pattern[1].

    [0]: https://github.com/JSQLParser/JSqlParser

  • A note from our sponsor - WorkOS
    workos.com | 25 Apr 2024
    The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →

Stats

Basic JSqlParser repo stats
4
4,956
9.2
5 days ago

Sponsored
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com