JSQLParser/JSqlParser
JSqlParser
JSqlParser es una biblioteca Java para el análisis de consultas SQL, que convierte cadenas SQL sin procesar en una jerarquía estructurada de objetos Java fuertemente tipados. Proporciona los medios para analizar y manipular programáticamente las consultas de bases de datos representándolas como un árbol de objetos.
La biblioteca admite tanto el análisis de texto SQL existente como la generación programática de nuevas sentencias a través de una API fluida. Incluye mecanismos para transformar árboles de consulta y serializar modelos de objetos estructurados de nuevo en texto SQL formateado.
Las capacidades adicionales incluyen el análisis de esquemas de bases de datos, como la extracción de nombres de tablas para mapear dependencias de datos, y la validación de sintaxis SQL. El analizador es configurable para manejar diferentes dialectos de sintaxis e incluye recuperación tolerante a errores para continuar procesando scripts después de encontrar tokens no válidos.
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.
