Generate type-safe code from SQL
This report summarizes scanner evidence for sqlc-dev/sqlc, a Go project with 18,428 GitHub stars. SynthScan examined 256,894 lines of code across 7426 source files, recording 65 pattern matches distributed across 3 syntactic categories. The legacy adjusted pattern signal is 0.3 (Low 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? 65 finding(s).
Are imports declared and package/API names verified? 0 finding(s).
Are wrappers, guards, and repeated structures necessary? 0 finding(s).
Which changes need focused human review? 65 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 65 distinct pattern matches across 3 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 |
|---|---|---|---|---|
| LOW | gomod_test.go | 1 | package sqlc | COMMENT |
| LOW | cmd/sqlc-test-setup/v6to4/v6to4.c | 1 | // v6to4 is an LD_PRELOAD library that lets a program which insists on IPv6 | COMMENT |
| LOW | internal/sqlcdebug/sqlcdebug.go | 1 | // Package sqlcdebug parses the SQLCDEBUG environment variable and exposes | COMMENT |
| LOW | internal/core/db.go | 1 | package core | COMMENT |
| LOW | internal/core/cache.go | 21 | // database/sql connection, which the serialization API needs. | COMMENT |
| LOW | internal/core/dialect.go | 61 | COMMENT | |
| LOW | internal/core/seed/seed.go | 1 | // Package seed builds a core catalog for a SQL dialect from a declarative | COMMENT |
| LOW | internal/core/seed/seed.go | 81 | COMMENT | |
| LOW | internal/core/seed/seed.go | 101 | CastCategories string `json:"cast_categories,omitempty"` | COMMENT |
| LOW | internal/core/seed/seed.go | 121 | // type argument, such as the max of nvarchar(max), and IdentArgs the | COMMENT |
| LOW | internal/goldeneye/cmd/goldeneye/main.go | 1 | // Command goldeneye generates the dialect seeds under | COMMENT |
| LOW | internal/goldeneye/cmd/goldeneye/main.go | 61 | // engine is one database goldeneye knows how to read a dialect from. | COMMENT |
| LOW | internal/goldeneye/clickhouse/clickhouse.go | 1 | // Package clickhouse generates the ClickHouse dialect seed under | COMMENT |
| LOW | internal/goldeneye/clickhouse/types.go | 1 | package clickhouse | COMMENT |
| LOW | internal/goldeneye/clickhouse/types.go | 21 | // {"name": "map", "args": [ | COMMENT |
| LOW | internal/goldeneye/sqlite/sqlite.go | 1 | // Package sqlite generates the SQLite dialect seed under | COMMENT |
| LOW | internal/goldeneye/sqlite/sqlite.go | 21 | // over no rows. | COMMENT |
| LOW | internal/goldeneye/sqlite/signatures.go | 1 | package sqlite | COMMENT |
| LOW | internal/goldeneye/sqlite/bytecode.go | 1 | package sqlite | COMMENT |
| LOW | internal/goldeneye/sqlite/bytecode.go | 21 | // through the query tree to the column it is compared with. | COMMENT |
| LOW | internal/goldeneye/sqlite/install.go | 21 | // DefaultVersion is the SQLite release the dialect is generated from. It is | COMMENT |
| LOW | internal/goldeneye/sqlite/install.go | 161 | } | COMMENT |
| LOW | internal/goldeneye/mysql/mysql.go | 1 | // Package mysql generates the MySQL dialect seed under | COMMENT |
| LOW | internal/goldeneye/mysql/analyze.go | 21 | // with every parameter a user variable set to NULL, and each result | COMMENT |
| LOW | internal/goldeneye/duckdb/analyze.go | 21 | COMMENT | |
| LOW | internal/goldeneye/duckdb/duckdb.go | 1 | // Package duckdb generates the DuckDB dialect seed under | COMMENT |
| LOW | internal/goldeneye/spanner/plan.go | 1 | package spanner | COMMENT |
| LOW | internal/goldeneye/spanner/spanner.go | 1 | // Package spanner generates the GoogleSQL dialect seed under | COMMENT |
| LOW | internal/goldeneye/spanner/analyze.go | 21 | // leaves undeclared, and the query plan. The metadata types a value the | COMMENT |
| LOW | internal/goldeneye/mssql/mssql.go | 1 | // Package mssql generates the SQL Server dialect seed under | COMMENT |
| LOW | internal/goldeneye/mssql/plan.go | 1 | package mssql | COMMENT |
| LOW | internal/goldeneye/mssql/analyze.go | 21 | // whether it can be NULL, and which table column it is read from. What | COMMENT |
| LOW | internal/cache/cache.go | 1 | // Package cache implements sqlc's on-disk cache, designed after Bazel's | COMMENT |
| LOW | internal/inflection/singular.go | 21 | // Manual fix for incorrect handling of "campus" | COMMENT |
| LOW | internal/docs/lint.go | 1 | // Package docs validates the documentation content contract for docs/. | COMMENT |
| LOW | internal/codegen/golang/duckdb_type.go | 1 | package golang | COMMENT |
| LOW | internal/codegen/golang/clickhouse_type.go | 1 | package golang | COMMENT |
| LOW | internal/codegen/golang/clickhouse_type.go | 21 | // Value method, and a {name:Type} placeholder is sent as text formatted | COMMENT |
| LOW | internal/codegen/golang/opts/override_test.go | 21 | "github.com/segmentio/ksuid", | COMMENT |
| LOW | internal/codegen/sdk/utils.go | 21 | COMMENT | |
| LOW | …a/batch_parameter_limit/postgresql/pgx/go/query.sql.go | 1 | // Code generated by sqlc. DO NOT EDIT. | COMMENT |
| LOW | internal/endtoend/testdata/cte_select_one/issue.md | 1 | # TODO | COMMENT |
| LOW | internal/endtoend/testdata/params_go_keywords/issue.md | 1 | # TODO | COMMENT |
| LOW | …ta/batch_parameter_type/postgresql/pgx/go/query.sql.go | 1 | // Code generated by sqlc. DO NOT EDIT. | COMMENT |
| LOW | internal/endtoend/testdata/cte_recursive_union/issue.md | 1 | # TODO | COMMENT |
| LOW | …toend/testdata/batch/postgresql/pgx/v5/go/query.sql.go | 1 | // Code generated by sqlc. DO NOT EDIT. | COMMENT |
| LOW | …toend/testdata/batch/postgresql/pgx/v4/go/query.sql.go | 1 | // Code generated by sqlc. DO NOT EDIT. | COMMENT |
| LOW | …opyfrom_singlecolumn/postgresql/pgx/v5/go/query.sql.go | 1 | // Code generated by sqlc. DO NOT EDIT. | COMMENT |
| LOW | …opyfrom_singlecolumn/postgresql/pgx/v4/go/query.sql.go | 1 | // Code generated by sqlc. DO NOT EDIT. | COMMENT |
| LOW | internal/opts/experiment.go | 1 | package opts | COMMENT |
| LOW | internal/opts/experiment.go | 21 | // SQLCEXPERIMENT=foo,bar # enable foo and bar experiments | COMMENT |
| LOW | internal/engine/postgresql/seed.go | 21 | // a live PostgreSQL 16 server by goldeneye (internal/goldeneye), which also | COMMENT |
| LOW | internal/engine/dolphin/convert.go | 1521 | COMMENT | |
| LOW | internal/compiler/selector.go | 1 | package compiler | COMMENT |
| LOW | internal/x/expander/expander_test.go | 41 | COMMENT | |
| LOW | internal/sql/preprocess/preprocess.go | 1 | // Package preprocess rewrites sqlc's query syntax into native SQL before any | COMMENT |
| LOW | internal/sql/astutils/rewrite.go | 21 | COMMENT | |
| LOW | internal/sql/astutils/rewrite.go | 61 | // If p is a variable of type and value of the current parent node | COMMENT |
| LOW | internal/sql/format/format.go | 1 | package format | COMMENT |
| LOW | internal/sql/ast/comment.go | 41 | // line) or leads the code after it (its own line). | COMMENT |
| 2 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | internal/opts/experiment.go | 19 | // Example usage: | COMMENT |
| LOW | pkg/cli/cli.go | 4 | // Example usage: | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | internal/codegen/golang/opts/override_test.go | 25 | // TODO: Add test for struct pointers | COMMENT |