What does jsqlparser/jsqlparser do?

JSqlParser ist eine Java-Bibliothek für SQL-Abfrage-Parsing, die rohe SQL-Strings in eine strukturierte Hierarchie stark typisierter Java-Objekte konvertiert. Sie bietet die Möglichkeit, Datenbankabfragen programmatisch zu analysieren und zu manipulieren, indem sie diese als Baum von Objekten darstellt.

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 - SQL in Java parsen und manipulie…

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.

Open-Source-Alternativen zu JSqlParser

Ähnliche Open-Source-Projekte, sortiert nach der Anzahl der gemeinsamen Funktionen mit JSqlParser.

jooq/jooq
jOOQ/jOOQ
6,666Auf GitHub ansehen
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
Auf GitHub ansehen6,666
andialbrecht/sqlparse
andialbrecht/sqlparse
4,008Auf GitHub ansehen
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
Auf GitHub ansehen4,008
dtolnay/syn
dtolnay/syn
3,292Auf GitHub ansehen
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
Auf GitHub ansehen3,292
pest-parser/pest
pest-parser/pest
5,355Auf GitHub ansehen
Pest is a Rust parsing library and automatic parser generator that transforms formal grammar definitions into functional parsers. It specializes in Parsing Expression Grammar to recognize and structure complex text patterns, providing a system for context-free grammar parsing. The library implements zero-copy tokenization and static grammar compilation to reduce runtime overhead. It supports no-std runtime compatibility, allowing the parser to be compiled for embedded or bare-metal environments where a standard library is unavailable. The project covers a range of parsing capabilities, inclu
Rust
Auf GitHub ansehen5,355

Alle 30 Alternativen zu JSqlParser anzeigen

JSqlParser - SQL in Java parsen und manipulie… | Awesome Repos

JSQLParserJSqlParser

JSqlParser

Features

Open-Source-Alternativen zu JSqlParser

jOOQ/jOOQ

andialbrecht/sqlparse

dtolnay/syn

pest-parser/pest

Frequently asked questions

Star-Verlauf

Frequently asked questions

Open-Source-Alternativen zu JSqlParser

jOOQ/jOOQ

andialbrecht/sqlparse

dtolnay/syn

pest-parser/pest