Home / JSQLParser / JSqlParser
AI Slop Code RIsk Monitor

JSQLParser/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

7.4 Moderate pattern signal View on GitHub

Maintenance and Governance Review

This report summarizes scanner evidence for JSQLParser/JSqlParser, a Java project with 5,965 GitHub stars. SynthScan examined 190,566 lines of code across 1486 source files, recording 151 pattern matches distributed across 6 syntactic categories. The legacy adjusted pattern signal is 7.4 (Moderate pattern signal); it is not an authorship estimate.

Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.

7.4
Adjusted Signal
7.4
Raw Pattern Score
100%
Time Factor
2026-10-11
Last Push
6.0K
Stars
Java
Language
190.6K
Lines of Code
1.5K
Files
151
Pattern Hits
2026-10-12
Scan Date
0.09
HC Hit Rate

Risk Review · v3

Use each vector to guide manual verification of the underlying findings.

Cognitive Ownership Risk 0.5/100 · LOW

Can maintainers explain intent, assumptions, and trade-offs? 17 finding(s).

Hallucinated Dependency & Supply Chain Risk 30.4/100 · MEDIUM

Are imports declared and package/API names verified? 132 finding(s).

Agent Over-Engineering Ratio 0.2/100 · LOW

Are wrappers, guards, and repeated structures necessary? 2 finding(s).

PR Review Velocity Impact 29.4/100 · MEDIUM

Which changes need focused human review? 151 finding(s).

What These Metrics Mean

Adjusted Signal
Legacy pattern score normalized per 1,000 scanned lines and multiplied by the repository-level time factor. It is not an estimate of AI authorship.
Raw Pattern Score
Sum of severity- and context-weighted pattern findings before applying the time factor.
Time Factor
A coarse multiplier based on repository last-push metadata. It does not identify when individual code was written.
Pattern Hits
Count of configured pattern findings. Review each location and surrounding code before acting.
HC Hit Rate
High- and critical-severity findings per scanned file. Severity is a configured detector weight, not proof of a vulnerability or authorship.
Lines / Files
Scan coverage denominators used by the legacy normalized score.

Pattern-Signal History

This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.

Severity Breakdown

Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.

CRITICAL 130HIGH 0MEDIUM 2LOW 19

Directory Score Breakdown

This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.

Pattern Findings

The scanner identified 151 distinct pattern matches across 6 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.

Reading the findings table: The Severity column indicates the configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.

Hallucination Indicators130 hits · 1378 pts
SeverityFileLineSnippetContext
CRITICAL⚡CHANGELOG.md1000* at org.junit.jupiter.api.AssertionFailureBuilder.build(AssertionFailureBuilder.java:151)COMMENT
CRITICAL⚡CHANGELOG.md1001* at org.junit.jupiter.api.AssertionFailureBuilder.buildAndThrow(AssertionFailureBuilder.java:132)COMMENT
CRITICAL⚡CHANGELOG.md1002* at org.junit.jupiter.api.AssertEquals.failNotEqual(AssertEquals.java:197)COMMENT
CRITICAL⚡CHANGELOG.md1003* at org.junit.jupiter.api.AssertEquals.assertEquals(AssertEquals.java:182)COMMENT
CRITICAL⚡CHANGELOG.md1004* at org.junit.jupiter.api.Assertions.assertEquals(Assertions.java:1156)COMMENT
CRITICAL⚡CHANGELOG.md1005* at net.sf.jsqlparser@5.2-SNAPSHOT/net.sf.jsqlparser.test.TestUtils.assertStatementCanBeDeparsedAs(TestUtils.java:126)COMMENT
CRITICAL⚡CHANGELOG.md1006* at net.sf.jsqlparser@5.2-SNAPSHOT/net.sf.jsqlparser.test.TestUtils.assertSqlCanBeParsedAndDeparsed(TestUtils.java:99)COMMENT
CRITICAL⚡CHANGELOG.md1007* at net.sf.jsqlparser@5.2-SNAPSHOT/net.sf.jsqlparser.test.TestUtils.assertSqlCanBeParsedAndDeparsed(TestUtils.java:85)COMMENT
CRITICAL⚡CHANGELOG.md1008* at net.sf.jsqlparser@5.2-SNAPSHOT/net.sf.jsqlparser.statement.select.TableFunctionTest.testTableFunctionWithSupportedWCOMMENT
CRITICAL…net/sf/jsqlparser/benchmark/LatestClasspathRunner.java21 return net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(sql, executorService,CODE
CRITICAL…ava/net/sf/jsqlparser/statement/select/DuckDBTest.java209 .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr)));CODE
CRITICAL…ava/net/sf/jsqlparser/statement/select/DuckDBTest.java405 .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr)));CODE
CRITICAL…ava/net/sf/jsqlparser/statement/select/DuckDBTest.java469 .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr)));CODE
CRITICAL…ava/net/sf/jsqlparser/statement/select/DuckDBTest.java598 .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr)));CODE
CRITICAL…ava/net/sf/jsqlparser/statement/select/DuckDBTest.java633 .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr)));CODE
CRITICAL…/sf/jsqlparser/statement/select/SpecialOracleTest.java148 net.sf.jsqlparser.parser.ParseException.class.getCanonicalName())) {CODE
CRITICAL…a/net/sf/jsqlparser/statement/select/BigQueryTest.java274 .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr)));CODE
CRITICAL…a/net/sf/jsqlparser/statement/select/BigQueryTest.java318 .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr)));CODE
CRITICAL…jsqlparser/statement/execute/ExecuteArgumentsTest.java123 new net.sf.jsqlparser.util.deparser.ExecuteDeParser(expressions, text).deParse(execute);CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java176 // new net.sf.jsqlparser.statement.select.AllTableColumns(new Table()),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java186 // new net.sf.jsqlparser.statement.select.LateralSubSelect("LATERAL"),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java187 // new net.sf.jsqlparser.statement.select.Limit(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java192 // new net.sf.jsqlparser.statement.select.ParenthesisFromItem().getFromItem(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java194 // new net.sf.jsqlparser.statement.select.PivotXml(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java195 // new net.sf.jsqlparser.statement.select.PlainSelect(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java196 // new net.sf.jsqlparser.statement.select.Select(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java198 // new net.sf.jsqlparser.statement.select.SetOperationList(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java200 // new net.sf.jsqlparser.statement.select.ParenthesedSelect(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java201 // new net.sf.jsqlparser.statement.select.TableFunction("LATERAL", new Function()),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java206 // new net.sf.jsqlparser.statement.select.WithItem(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java210 // new net.sf.jsqlparser.statement.select.ValuesStatement(),COMMENT
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java88 new net.sf.jsqlparser.expression.operators.arithmetic.Addition(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java89 new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseAnd(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java90 new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseLeftShift(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java91 new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseOr(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java92 new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseRightShift(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java93 new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseXor(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java94 new net.sf.jsqlparser.expression.operators.arithmetic.Concat(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java95 new net.sf.jsqlparser.expression.operators.arithmetic.Division(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java96 new net.sf.jsqlparser.expression.operators.arithmetic.IntegerDivision(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java97 new net.sf.jsqlparser.expression.operators.arithmetic.Modulo(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java98 new net.sf.jsqlparser.expression.operators.arithmetic.Multiplication(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java99 new net.sf.jsqlparser.expression.operators.arithmetic.Subtraction(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java100 new net.sf.jsqlparser.expression.operators.conditional.AndExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java101 new net.sf.jsqlparser.expression.operators.conditional.OrExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java102 new net.sf.jsqlparser.expression.operators.conditional.XorExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java103 new net.sf.jsqlparser.expression.operators.relational.Between(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java104 new net.sf.jsqlparser.expression.operators.relational.EqualsTo(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java105 new net.sf.jsqlparser.expression.operators.relational.ExistsExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java107 new net.sf.jsqlparser.expression.operators.relational.FullTextSearch(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java108 new net.sf.jsqlparser.expression.operators.relational.GreaterThan(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java109 new net.sf.jsqlparser.expression.operators.relational.GreaterThanEquals(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java110 new net.sf.jsqlparser.expression.operators.relational.InExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java111 new net.sf.jsqlparser.expression.operators.relational.IsBooleanExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java112 new net.sf.jsqlparser.expression.operators.relational.IsNullExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java113 new net.sf.jsqlparser.expression.operators.relational.IsUnknownExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java114 new net.sf.jsqlparser.expression.operators.relational.JsonOperator("@>"),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java115 new net.sf.jsqlparser.expression.operators.relational.LikeExpression(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java116 new net.sf.jsqlparser.expression.operators.relational.Matches(),CODE
CRITICAL⚡…/jsqlparser/statement/builder/ReflectionModelTest.java117 new net.sf.jsqlparser.expression.operators.relational.MinorThan(),CODE
70 more matches not shown…
Over-Commented Block13 hits · 13 pts
SeverityFileLineSnippetContext
LOWsrc/test/resources/RUBiS-select-requests.txt1// ---------------------------------------------------------------------------------------------------------------------COMMENT
LOWsrc/test/resources/RUBiS-create-requests.txt1// ---------------------------------------------------------------------------------------------------------------------COMMENT
LOWsrc/test/resources/RUBiS-create-requests.txt401Syntax error in this CREATE statement: 'create table foo id int4, name text)'COMMENT
LOWsrc/test/resources/RUBiS-create-requests.txt421//#beginCOMMENT
LOW…rces/net/sf/jsqlparser/util/complex-merge-requests.txt1// ---------------------------------------------------------------------------------------------------------------------COMMENT
LOW…ces/net/sf/jsqlparser/util/complex-select-requests.txt1// ---------------------------------------------------------------------------------------------------------------------COMMENT
LOW…sf/jsqlparser/util/deparser/StatementDeParserTest.java141 // withItem2.setSelect(mock(ParenthesedSelect.class));COMMENT
LOW…sf/jsqlparser/util/deparser/StatementDeParserTest.java261 then(expression).should().accept(expressionDeParser, null);COMMENT
LOW…/net/sf/jsqlparser/statement/select/SelectASTTest.java61 String sql = "SELECT a, b FROM mytable order by b, c";COMMENT
LOW…/net/sf/jsqlparser/statement/select/SelectASTTest.java81 // subSelectEnd = node.jjtGetLastToken();COMMENT
LOW…ava/net/sf/jsqlparser/statement/select/SelectTest.java3181COMMENT
LOW…ava/net/sf/jsqlparser/statement/select/SelectTest.java4001 // then 1::int2 else 3::int2 end as delete_rule, ref.conname as fk_name, cn.conname as pk_name,COMMENT
LOW…/net/sf/jsqlparser/util/cnfexpression/CloneHelper.java141 // result = new AndExpression(left, right);COMMENT
Decorative Section Separators2 hits · 6 pts
SeverityFileLineSnippetContext
MEDIUM…c/main/java/net/sf/jsqlparser/expression/Function.java318 // ── Generic keyword argument support ───────────────────────────────COMMENT
MEDIUM…c/main/java/net/sf/jsqlparser/expression/Function.java554 // ── KeywordArgument inner class ────────────────────────────────────COMMENT
Verbosity Indicators2 hits · 3 pts
SeverityFileLineSnippetContext
LOW…c/test/java/net/sf/jsqlparser/test/HowToUseSample.java73 // Step 1: generate the Java Object Hierarchy forCOMMENT
LOW…ava/net/sf/jsqlparser/statement/select/SelectTest.java5155 // Step 1: generate the Java Object Hierarchy forCOMMENT
Structural Annotation Overuse2 hits · 3 pts
SeverityFileLineSnippetContext
LOW…c/test/java/net/sf/jsqlparser/test/HowToUseSample.java73 // Step 1: generate the Java Object Hierarchy forCOMMENT
LOW…ava/net/sf/jsqlparser/statement/select/SelectTest.java5155 // Step 1: generate the Java Object Hierarchy forCOMMENT
Fake / Example Data2 hits · 2 pts
SeverityFileLineSnippetContext
LOW…ser/statement/insert/PostgreSQLConflictTargetTest.java67 "INSERT INTO users OVERRIDING " + mode + " VALUE VALUES (42, 'a@example.org', 'A')",CODE
LOW…st/java/net/sf/jsqlparser/expression/FunctionTest.java79 " ['foo@example.com', 'bar@example.org', 'www.example.net']\n" +CODE