JSqlParser parses an SQL statement and translate it into a hierarchy of Java classes. The generated hierarchy can be navigated using the Visitor Pattern
This report summarizes scanner evidence for JSQLParser/JSqlParser, a Java project with 5,970 GitHub stars. SynthScan examined 214,592 lines of code across 1576 source files, recording 150 pattern matches distributed across 6 syntactic categories. The legacy adjusted pattern signal is 6.5 (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.
Use each vector to guide manual verification of the underlying findings.
Payload schema: 1.0.0 · Engine: 2.0.0 · Scoring: heuristic-density-v1 · Scan date: 2026-10-31.
Can maintainers explain intent, assumptions, and trade-offs? 16 finding(s).
Are imports declared and package/API names verified? 132 finding(s).
Are wrappers, guards, and repeated structures necessary? 2 finding(s).
Which changes need focused human review? 150 finding(s).
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.
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.
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.
The scanner identified 150 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.
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| CRITICAL⚡ | CHANGELOG.md | 1000 | * at org.junit.jupiter.api.AssertionFailureBuilder.build(AssertionFailureBuilder.java:151) | COMMENT |
| CRITICAL⚡ | CHANGELOG.md | 1001 | * at org.junit.jupiter.api.AssertionFailureBuilder.buildAndThrow(AssertionFailureBuilder.java:132) | COMMENT |
| CRITICAL⚡ | CHANGELOG.md | 1002 | * at org.junit.jupiter.api.AssertEquals.failNotEqual(AssertEquals.java:197) | COMMENT |
| CRITICAL⚡ | CHANGELOG.md | 1003 | * at org.junit.jupiter.api.AssertEquals.assertEquals(AssertEquals.java:182) | COMMENT |
| CRITICAL⚡ | CHANGELOG.md | 1004 | * at org.junit.jupiter.api.Assertions.assertEquals(Assertions.java:1156) | COMMENT |
| CRITICAL⚡ | CHANGELOG.md | 1005 | * at net.sf.jsqlparser@5.2-SNAPSHOT/net.sf.jsqlparser.test.TestUtils.assertStatementCanBeDeparsedAs(TestUtils.java:126) | COMMENT |
| CRITICAL⚡ | CHANGELOG.md | 1006 | * at net.sf.jsqlparser@5.2-SNAPSHOT/net.sf.jsqlparser.test.TestUtils.assertSqlCanBeParsedAndDeparsed(TestUtils.java:99) | COMMENT |
| CRITICAL⚡ | CHANGELOG.md | 1007 | * at net.sf.jsqlparser@5.2-SNAPSHOT/net.sf.jsqlparser.test.TestUtils.assertSqlCanBeParsedAndDeparsed(TestUtils.java:85) | COMMENT |
| CRITICAL⚡ | CHANGELOG.md | 1008 | * at net.sf.jsqlparser@5.2-SNAPSHOT/net.sf.jsqlparser.statement.select.TableFunctionTest.testTableFunctionWithSupportedW | COMMENT |
| CRITICAL | …net/sf/jsqlparser/benchmark/LatestClasspathRunner.java | 21 | return net.sf.jsqlparser.parser.CCJSqlParserUtil.parseStatements(sql, executorService, | CODE |
| CRITICAL | …ava/net/sf/jsqlparser/statement/select/DuckDBTest.java | 218 | .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr))); | CODE |
| CRITICAL | …ava/net/sf/jsqlparser/statement/select/DuckDBTest.java | 414 | .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr))); | CODE |
| CRITICAL | …ava/net/sf/jsqlparser/statement/select/DuckDBTest.java | 478 | .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr))); | CODE |
| CRITICAL | …ava/net/sf/jsqlparser/statement/select/DuckDBTest.java | 683 | .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr))); | CODE |
| CRITICAL | …ava/net/sf/jsqlparser/statement/select/DuckDBTest.java | 718 | .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr))); | CODE |
| CRITICAL | …/sf/jsqlparser/statement/select/SpecialOracleTest.java | 148 | net.sf.jsqlparser.parser.ParseException.class.getCanonicalName())) { | CODE |
| CRITICAL | …a/net/sf/jsqlparser/statement/select/BigQueryTest.java | 274 | .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr))); | CODE |
| CRITICAL | …a/net/sf/jsqlparser/statement/select/BigQueryTest.java | 318 | .getTableList(net.sf.jsqlparser.parser.CCJSqlParserUtil.parse(sqlStr))); | CODE |
| CRITICAL | …jsqlparser/statement/execute/ExecuteArgumentsTest.java | 123 | new net.sf.jsqlparser.util.deparser.ExecuteDeParser(expressions, text).deParse(execute); | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 176 | // new net.sf.jsqlparser.statement.select.AllTableColumns(new Table()), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 186 | // new net.sf.jsqlparser.statement.select.LateralSubSelect("LATERAL"), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 187 | // new net.sf.jsqlparser.statement.select.Limit(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 192 | // new net.sf.jsqlparser.statement.select.ParenthesisFromItem().getFromItem(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 194 | // new net.sf.jsqlparser.statement.select.PivotXml(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 195 | // new net.sf.jsqlparser.statement.select.PlainSelect(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 196 | // new net.sf.jsqlparser.statement.select.Select(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 198 | // new net.sf.jsqlparser.statement.select.SetOperationList(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 200 | // new net.sf.jsqlparser.statement.select.ParenthesedSelect(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 201 | // new net.sf.jsqlparser.statement.select.TableFunction("LATERAL", new Function()), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 206 | // new net.sf.jsqlparser.statement.select.WithItem(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 210 | // new net.sf.jsqlparser.statement.select.ValuesStatement(), | COMMENT |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 88 | new net.sf.jsqlparser.expression.operators.arithmetic.Addition(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 89 | new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseAnd(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 90 | new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseLeftShift(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 91 | new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseOr(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 92 | new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseRightShift(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 93 | new net.sf.jsqlparser.expression.operators.arithmetic.BitwiseXor(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 94 | new net.sf.jsqlparser.expression.operators.arithmetic.Concat(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 95 | new net.sf.jsqlparser.expression.operators.arithmetic.Division(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 96 | new net.sf.jsqlparser.expression.operators.arithmetic.IntegerDivision(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 97 | new net.sf.jsqlparser.expression.operators.arithmetic.Modulo(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 98 | new net.sf.jsqlparser.expression.operators.arithmetic.Multiplication(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 99 | new net.sf.jsqlparser.expression.operators.arithmetic.Subtraction(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 100 | new net.sf.jsqlparser.expression.operators.conditional.AndExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 101 | new net.sf.jsqlparser.expression.operators.conditional.OrExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 102 | new net.sf.jsqlparser.expression.operators.conditional.XorExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 103 | new net.sf.jsqlparser.expression.operators.relational.Between(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 104 | new net.sf.jsqlparser.expression.operators.relational.EqualsTo(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 105 | new net.sf.jsqlparser.expression.operators.relational.ExistsExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 107 | new net.sf.jsqlparser.expression.operators.relational.FullTextSearch(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 108 | new net.sf.jsqlparser.expression.operators.relational.GreaterThan(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 109 | new net.sf.jsqlparser.expression.operators.relational.GreaterThanEquals(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 110 | new net.sf.jsqlparser.expression.operators.relational.InExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 111 | new net.sf.jsqlparser.expression.operators.relational.IsBooleanExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 112 | new net.sf.jsqlparser.expression.operators.relational.IsNullExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 113 | new net.sf.jsqlparser.expression.operators.relational.IsUnknownExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 114 | new net.sf.jsqlparser.expression.operators.relational.JsonOperator("@>"), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 115 | new net.sf.jsqlparser.expression.operators.relational.LikeExpression(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 116 | new net.sf.jsqlparser.expression.operators.relational.Matches(), | CODE |
| CRITICAL⚡ | …/jsqlparser/statement/builder/ReflectionModelTest.java | 117 | new net.sf.jsqlparser.expression.operators.relational.MinorThan(), | CODE |
| 70 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | src/test/resources/RUBiS-select-requests.txt | 1 | // --------------------------------------------------------------------------------------------------------------------- | COMMENT |
| LOW | src/test/resources/RUBiS-create-requests.txt | 1 | // --------------------------------------------------------------------------------------------------------------------- | COMMENT |
| LOW | src/test/resources/RUBiS-create-requests.txt | 401 | Syntax error in this CREATE statement: 'create table foo id int4, name text)' | COMMENT |
| LOW | src/test/resources/RUBiS-create-requests.txt | 421 | //#begin | COMMENT |
| LOW | …rces/net/sf/jsqlparser/util/complex-merge-requests.txt | 1 | // --------------------------------------------------------------------------------------------------------------------- | COMMENT |
| LOW | …ces/net/sf/jsqlparser/util/complex-select-requests.txt | 1 | // --------------------------------------------------------------------------------------------------------------------- | COMMENT |
| LOW | …sf/jsqlparser/util/deparser/StatementDeParserTest.java | 141 | // withItem2.setSelect(mock(ParenthesedSelect.class)); | COMMENT |
| LOW | …sf/jsqlparser/util/deparser/StatementDeParserTest.java | 261 | then(expression).should().accept(expressionDeParser, null); | COMMENT |
| LOW | …/net/sf/jsqlparser/statement/select/SelectASTTest.java | 81 | // subSelectStart = node.jjtGetFirstToken(); | COMMENT |
| LOW | …ava/net/sf/jsqlparser/statement/select/SelectTest.java | 3221 | } | COMMENT |
| LOW | …ava/net/sf/jsqlparser/statement/select/SelectTest.java | 4041 | // ref.confdeltype when 'c' then 0::int2 when 'n' then 2::int2 when 'd' then 4::int2 when 'r' | COMMENT |
| LOW | …/net/sf/jsqlparser/util/cnfexpression/CloneHelper.java | 141 | // result = new AndExpression(left, right); | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | …c/main/java/net/sf/jsqlparser/expression/Function.java | 318 | // ── Generic keyword argument support ─────────────────────────────── | COMMENT |
| MEDIUM | …c/main/java/net/sf/jsqlparser/expression/Function.java | 554 | // ── KeywordArgument inner class ──────────────────────────────────── | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | …c/test/java/net/sf/jsqlparser/test/HowToUseSample.java | 73 | // Step 1: generate the Java Object Hierarchy for | COMMENT |
| LOW | …ava/net/sf/jsqlparser/statement/select/SelectTest.java | 5196 | // Step 1: generate the Java Object Hierarchy for | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | …c/test/java/net/sf/jsqlparser/test/HowToUseSample.java | 73 | // Step 1: generate the Java Object Hierarchy for | COMMENT |
| LOW | …ava/net/sf/jsqlparser/statement/select/SelectTest.java | 5196 | // Step 1: generate the Java Object Hierarchy for | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | …ser/statement/insert/PostgreSQLConflictTargetTest.java | 67 | "INSERT INTO users OVERRIDING " + mode + " VALUE VALUES (42, 'a@example.org', 'A')", | CODE |
| LOW | …st/java/net/sf/jsqlparser/expression/FunctionTest.java | 79 | " ['foo@example.com', 'bar@example.org', 'www.example.net']\n" + | CODE |