2 repositorios
Specialized validators that detect structural issues in SQL queries such as unused CTEs and redundant statements.
Distinct from Structural Data Validators: Parent focuses on general data structure validation; this specifically targets SQL query logical structure.
Explore 2 awesome GitHub repositories matching data & databases · SQL Query Structure Validators. Refine with filters or upvote what's useful.
SQLFluff is a multi-dialect SQL linter, formatter, and style guide enforcer. It functions as a parser and analyzer that converts SQL scripts into structured trees to validate syntax, identify logical components, and enforce consistent capitalization, aliasing, and layout conventions across various database dialects. The system is specifically designed to handle templated SQL, providing the ability to analyze, parse, and lint files containing macros or placeholders. It uses dummy-parameter rendering and source mapping to validate the style and correctness of dynamic code before it is rendered
Detects structural issues such as unused common table expressions, redundant statements, and ambiguous groupings.
Soar is a suite of specialized tools designed for analyzing MySQL performance, advising on indexing, and optimizing SQL syntax. It functions as a performance analyzer, index advisor, and query optimizer to identify bottlenecks and suggest structural improvements for faster execution. The project distinguishes itself through a system for rewriting SQL statements into optimized equivalent versions using custom heuristic rules and patterns. It also features a dedicated index advisor that evaluates query patterns and database metadata to recommend the creation of new indexes. Its broader capabil
Detects structural issues and syntax errors in SQL queries to ensure they are syntactically correct.