What does jsqlparser/jsqlparser do?

JSqlParser este o bibliotecă Java pentru parsarea interogărilor SQL, convertind șirurile SQL brute într-o ierarhie structurată de obiecte Java puternic tipizate. Oferă mijloacele de a analiza și manipula programatic interogările bazei de date prin reprezentarea lor ca un arbore de obiecte.

What are the main features of jsqlparser/jsqlparser?

The main features of jsqlparser/jsqlparser are: SQL Query Object Models, Fluent Query Construction, SQL Query Builders, SQL Statement Generators, SQL Query Generation, SQL Serialization, SQL Statement Parsing, Dialect-Aware Parsers.

What are some open-source alternatives to jsqlparser/jsqlparser?

Open-source alternatives to jsqlparser/jsqlparser include: jooq/jooq — jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time… andialbrecht/sqlparse — sqlparse is a Python library for the programmatic analysis and manipulation of SQL statements. It provides a… dtolnay/syn — syn is a Rust syntax tree parser and token stream converter. It serves as a toolkit for procedural macro development,… pest-parser/pest — Pest is a Rust parsing library and automatic parser generator that transforms formal grammar definitions into… tobymao/sqlglot — sqlglot is a SQL parser and transpiler that represents queries as abstract syntax trees to enable structural analysis,… rmosolgo/graphql-ruby — GraphQL-Ruby is a Ruby library for building GraphQL APIs with a strongly typed schema and a dedicated query execution…

JSqlParser - analizează și manipulează SQL în…

JSqlParser - analizează și manipulează SQL în… | Awesome Repos

Features

SQL Query Object Models - Converts raw SQL strings into a structured hierarchy of strongly typed Java objects for analysis and manipulation.
Fluent Query Construction - Provides a programmatic, object-oriented fluent interface for constructing structured SQL statements.
SQL Query Builders - Provides a programmatic tool for building SQL queries using a fluent API.
SQL Statement Generators - Generates precise SQL statements from programmatic definitions using a fluent interface.
SQL Query Generation - Converts programmatic query definitions into formatted SQL strings compatible with database engines.
SQL Serialization - Serializes structured object models back into formatted SQL text for execution on database engines.
SQL Statement Parsing - Converts database dialect strings into a structured object hierarchy for programmatic analysis and modification.
Dialect-Aware Parsers - Provides parsing logic that adapts to various SQL dialect specifications for different database engines.
Statement - Represents parsed SQL statements as a tree of Java objects to allow programmatic manipulation via type safety.
SQL and Database Analysis - Analyzes raw SQL queries to extract table names and map data structures and dependencies.
Syntax Validation - Provides mechanisms to check database queries for correctness and handle syntax errors during the processing of SQL scripts.
Query Rewriting - Navigates and modifies parsed SQL statement trees to rewrite or optimize queries.
Table Dependency Extraction - Identifies and lists every table referenced within a structured query to map data dependencies.
Tree Traversal - Provides interfaces for programmatically visiting nodes within the parsed SQL statement hierarchy.
AST Visitor Patterns - Implements the visitor design pattern for traversing and modifying abstract syntax trees of SQL queries.
Parse Error Reporters - Identifies invalid tokens and handles parsing errors to allow the processing of remaining statements in a script.
Parsing Error Recovery - Includes error-tolerant recovery to continue processing SQL scripts after encountering invalid tokens.
SQL Parsers - Parses SQL statements into a hierarchy of Java classes.

Alternative open-source pentru JSqlParser

Proiecte open-source similare, clasificate după numărul de funcționalități comune cu JSqlParser.

jooq/jooq
jOOQ/jOOQ
6,666Vezi pe GitHub
jOOQ is a type-safe SQL query builder for Java that generates code from live database schemas, enabling compile-time validation of SQL syntax and data types. Its core identity is built around a fluent DSL that mirrors SQL structure, a code generator that maps tables, views, and routines to Java objects, and a multi-dialect engine that translates the same DSL into vendor-specific SQL for over 30 databases. The project also includes a SQL parser and transformer for refactoring or dialect conversion, reactive stream integration for non-blocking query execution, and a JDBC proxy diagnostics tool f
Javacode-generatordatabasedb2
Vezi pe GitHub6,666
andialbrecht/sqlparse
andialbrecht/sqlparse
4,008Vezi pe GitHub
sqlparse is a Python library for the programmatic analysis and manipulation of SQL statements. It provides a non-validating parser that breaks down SQL text into tokens and a utility to divide strings containing multiple queries into individual statements. The project includes a code formatter that reorganizes SQL statements using consistent indentation and keyword casing. It also provides mechanisms for automating this formatting and linting process through version control hooks to maintain code consistency.
Python
Vezi pe GitHub4,008
dtolnay/syn
dtolnay/syn
3,292Vezi pe GitHub
syn is a Rust syntax tree parser and token stream converter. It serves as a toolkit for procedural macro development, providing a framework to parse Rust source code into structured syntax trees for analysis and transformation. The project enables the manipulation of Rust abstract syntax trees through specialized visitor and folder patterns for traversing and mutating nodes. It provides a bidirectional mapping that allows developers to convert token streams into structured trees and print those trees back into tokens for code generation. The library covers a broad range of syntax analysis ca
Rustproc-macro
Vezi pe GitHub3,292

JSQLParserJSqlParser

JSqlParser

Features

Alternative open-source pentru JSqlParser

jOOQ/jOOQ

andialbrecht/sqlparse

dtolnay/syn

Frequently asked questions

Istoric stele

Frequently asked questions

Alternative open-source pentru JSqlParser

jOOQ/jOOQ

andialbrecht/sqlparse

dtolnay/syn

pest-parser/pest