{"$schema":"https://json.schemastore.org/sarif-2.1.0.json","version":"2.1.0","runs":[{"tool":{"driver":{"name":"codehealth","informationUri":"https://codehealth.canine.dev","rules":[{"id":"D1","name":"Cyclomatic Complexity","shortDescription":{"text":"Cyclomatic Complexity"},"helpUri":"https://codehealth.canine.dev/dimensions/D1"},{"id":"D2","name":"Cognitive Complexity","shortDescription":{"text":"Cognitive Complexity"},"helpUri":"https://codehealth.canine.dev/dimensions/D2"},{"id":"D3","name":"God Classes","shortDescription":{"text":"God Classes"},"helpUri":"https://codehealth.canine.dev/dimensions/D3"},{"id":"D4","name":"Code Duplication","shortDescription":{"text":"Code Duplication"},"helpUri":"https://codehealth.canine.dev/dimensions/D4"},{"id":"D5","name":"Coupling","shortDescription":{"text":"Coupling"},"helpUri":"https://codehealth.canine.dev/dimensions/D5"},{"id":"D6","name":"Cohesion (LCOM4)","shortDescription":{"text":"Cohesion (LCOM4)"},"helpUri":"https://codehealth.canine.dev/dimensions/D6"},{"id":"D8","name":"Code Coverage","shortDescription":{"text":"Code Coverage"},"helpUri":"https://codehealth.canine.dev/dimensions/D8"},{"id":"D11","name":"Test Reliability","shortDescription":{"text":"Test Reliability"},"helpUri":"https://codehealth.canine.dev/dimensions/D11"},{"id":"D13","name":"Secret Scanning","shortDescription":{"text":"Secret Scanning"},"helpUri":"https://codehealth.canine.dev/dimensions/D13","relationships":[{"target":{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-259","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"A07:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}},"kinds":["relevant"]}],"properties":{"cwe":["CWE-798","CWE-259"],"owasp":"A07:2025"}},{"id":"D14","name":"License Compliance","shortDescription":{"text":"License Compliance"},"helpUri":"https://codehealth.canine.dev/dimensions/D14"},{"id":"D15","name":"Churn \u00D7 Complexity Hotspots","shortDescription":{"text":"Churn \u00D7 Complexity Hotspots"},"helpUri":"https://codehealth.canine.dev/dimensions/D15"},{"id":"D20","name":"ADR Quality","shortDescription":{"text":"ADR Quality"},"helpUri":"https://codehealth.canine.dev/dimensions/D20"},{"id":"D26","name":"Project Cohesion","shortDescription":{"text":"Project Cohesion"},"helpUri":"https://codehealth.canine.dev/dimensions/D26"},{"id":"D27","name":"Navigability","shortDescription":{"text":"Navigability"},"helpUri":"https://codehealth.canine.dev/dimensions/D27"},{"id":"D28","name":"Secrets (history)","shortDescription":{"text":"Secrets (history)"},"helpUri":"https://codehealth.canine.dev/dimensions/D28","relationships":[{"target":{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-259","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"A07:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}},"kinds":["relevant"]}],"properties":{"cwe":["CWE-798","CWE-259"],"owasp":"A07:2025"}},{"id":"D29","name":"Static Analysis (SAST)","shortDescription":{"text":"Static Analysis (SAST)"},"helpUri":"https://codehealth.canine.dev/dimensions/D29","relationships":[{"target":{"id":"CWE-79","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-89","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-78","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-94","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-77","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"A05:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}},"kinds":["relevant"]}],"properties":{"cwe":["CWE-79","CWE-89","CWE-78","CWE-94","CWE-77"],"owasp":"A05:2025"}},{"id":"D30","name":"Dependency Vulnerabilities","shortDescription":{"text":"Dependency Vulnerabilities"},"helpUri":"https://codehealth.canine.dev/dimensions/D30","relationships":[{"target":{"id":"CWE-1395","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-937","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}},"kinds":["relevant"]}],"properties":{"cwe":["CWE-1395","CWE-937"],"owasp":"A03:2025"}},{"id":"D31","name":"IaC \u0026 Container Security","shortDescription":{"text":"IaC \u0026 Container Security"},"helpUri":"https://codehealth.canine.dev/dimensions/D31","relationships":[{"target":{"id":"CWE-1032","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-732","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-16","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"A02:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}},"kinds":["relevant"]}],"properties":{"cwe":["CWE-1032","CWE-732","CWE-16"],"owasp":"A02:2025"}},{"id":"D34","name":"Knowledge Freshness","shortDescription":{"text":"Knowledge Freshness"},"helpUri":"https://codehealth.canine.dev/dimensions/D34"},{"id":"D35","name":"Change Coupling","shortDescription":{"text":"Change Coupling"},"helpUri":"https://codehealth.canine.dev/dimensions/D35"},{"id":"D36","name":"Supply-chain Provenance \u0026 Signing","shortDescription":{"text":"Supply-chain Provenance \u0026 Signing"},"helpUri":"https://codehealth.canine.dev/dimensions/D36","relationships":[{"target":{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"CWE-494","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}},"kinds":["relevant"]}],"properties":{"cwe":["CWE-1357","CWE-494"],"owasp":"A03:2025"}},{"id":"D43","name":"Malicious Dependencies","shortDescription":{"text":"Malicious Dependencies"},"helpUri":"https://codehealth.canine.dev/dimensions/D43","relationships":[{"target":{"id":"CWE-506","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},"kinds":["relevant"]},{"target":{"id":"A08:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}},"kinds":["relevant"]}],"properties":{"cwe":["CWE-506"],"owasp":"A08:2025"}},{"id":"D44","name":"Platform End-of-Life","shortDescription":{"text":"Platform End-of-Life"},"helpUri":"https://codehealth.canine.dev/dimensions/D44"},{"id":"AX10","name":"Code composition","shortDescription":{"text":"Code composition"},"helpUri":"https://codehealth.canine.dev/dimensions/AX10"},{"id":"AX3","name":"Project dependency cycles","shortDescription":{"text":"Project dependency cycles"},"helpUri":"https://codehealth.canine.dev/dimensions/AX3"},{"id":"AX4","name":"Dependency direction","shortDescription":{"text":"Dependency direction"},"helpUri":"https://codehealth.canine.dev/dimensions/AX4"},{"id":"AX8","name":"Test isolation","shortDescription":{"text":"Test isolation"},"helpUri":"https://codehealth.canine.dev/dimensions/AX8"},{"id":"AXB2","name":"Runtime readiness","shortDescription":{"text":"Runtime readiness"},"helpUri":"https://codehealth.canine.dev/dimensions/AXB2"},{"id":"ED5","name":"Idempotency","shortDescription":{"text":"Idempotency"},"helpUri":"https://codehealth.canine.dev/dimensions/ED5"},{"id":"GD1","name":"Unfinished \u0026 placeholder code","shortDescription":{"text":"Unfinished \u0026 placeholder code"},"helpUri":"https://codehealth.canine.dev/dimensions/GD1"},{"id":"M1","name":"Documentation (README)","shortDescription":{"text":"Documentation (README)"},"helpUri":"https://codehealth.canine.dev/dimensions/M1"},{"id":"M2","name":"Architecture documentation","shortDescription":{"text":"Architecture documentation"},"helpUri":"https://codehealth.canine.dev/dimensions/M2"},{"id":"M3","name":"Folder \u0026 project structure","shortDescription":{"text":"Folder \u0026 project structure"},"helpUri":"https://codehealth.canine.dev/dimensions/M3"},{"id":"P1","name":"CI/CD gates","shortDescription":{"text":"CI/CD gates"},"helpUri":"https://codehealth.canine.dev/dimensions/P1"},{"id":"P12","name":"CI test-gate honesty","shortDescription":{"text":"CI test-gate honesty"},"helpUri":"https://codehealth.canine.dev/dimensions/P12"},{"id":"P2","name":"Observability","shortDescription":{"text":"Observability"},"helpUri":"https://codehealth.canine.dev/dimensions/P2"},{"id":"P3","name":"Security \u0026 performance tooling","shortDescription":{"text":"Security \u0026 performance tooling"},"helpUri":"https://codehealth.canine.dev/dimensions/P3"},{"id":"P4","name":"Deployment \u0026 Rollback","shortDescription":{"text":"Deployment \u0026 Rollback"},"helpUri":"https://codehealth.canine.dev/dimensions/P4"},{"id":"P5","name":"DR \u0026 Backup","shortDescription":{"text":"DR \u0026 Backup"},"helpUri":"https://codehealth.canine.dev/dimensions/P5"},{"id":"P6","name":"Release Hygiene","shortDescription":{"text":"Release Hygiene"},"helpUri":"https://codehealth.canine.dev/dimensions/P6"},{"id":"PF3","name":"Async \u0026 latency hygiene","shortDescription":{"text":"Async \u0026 latency hygiene"},"helpUri":"https://codehealth.canine.dev/dimensions/PF3"},{"id":"SC1","name":"Supply-chain hygiene","shortDescription":{"text":"Supply-chain hygiene"},"helpUri":"https://codehealth.canine.dev/dimensions/SC1"},{"id":"X10","name":"Duplicated predicate","shortDescription":{"text":"Duplicated predicate"},"helpUri":"https://codehealth.canine.dev/dimensions/X10"},{"id":"X20","name":"Mistyped argument guard","shortDescription":{"text":"Mistyped argument guard"},"helpUri":"https://codehealth.canine.dev/dimensions/X20"},{"id":"X23","name":"Unguarded diagnostic materialisation","shortDescription":{"text":"Unguarded diagnostic materialisation"},"helpUri":"https://codehealth.canine.dev/dimensions/X23"},{"id":"X27","name":"Collection changed while being enumerated","shortDescription":{"text":"Collection changed while being enumerated"},"helpUri":"https://codehealth.canine.dev/dimensions/X27"},{"id":"X28","name":"Index access outside its own emptiness guard","shortDescription":{"text":"Index access outside its own emptiness guard"},"helpUri":"https://codehealth.canine.dev/dimensions/X28"},{"id":"X9","name":"Subsumed condition operand","shortDescription":{"text":"Subsumed condition operand"},"helpUri":"https://codehealth.canine.dev/dimensions/X9"}]}},"results":[{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitWhere (cyclomatic 108): LinqExpressionVisitors.visitWhere has cyclomatic complexity 108 (threshold 15). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Where every arm is uniform \u2014 the same kind of value, with no behaviour of its own \u2014 a table keyed by the case is the shorter form; wherever the arms carry different data or different behaviour, keep them as cases, because collapsing those trades an explicit, reviewable set of cases for nothing. This file is where this pass\u0027s cyclomatic complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 7 of the 10 methods over the threshold \u2014 including the worst \u2014 and 208 of the 229 points over it (91%), 14.9\u00D7 the next-largest file (src/SqlHydra.Query/SqlEmitterBase.fs at 14). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":768}}}],"partialFingerprints":{"codehealthFindingId/v1":"2a858b4449c77313151605ac23837ca8ab021fca8d5747be9fffd1a1a4e6af16"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitSelect (cyclomatic 57): LinqExpressionVisitors.visitSelect has cyclomatic complexity 57 (threshold 15). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Where every arm is uniform \u2014 the same kind of value, with no behaviour of its own \u2014 a table keyed by the case is the shorter form; wherever the arms carry different data or different behaviour, keep them as cases, because collapsing those trades an explicit, reviewable set of cases for nothing. This file is where this pass\u0027s cyclomatic complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 7 of the 10 methods over the threshold \u2014 including the worst \u2014 and 208 of the 229 points over it (91%), 14.9\u00D7 the next-largest file (src/SqlHydra.Query/SqlEmitterBase.fs at 14). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1648}}}],"partialFingerprints":{"codehealthFindingId/v1":"802393090df9aa278db72f32686440c52999f744e5a6c319051b8ce48dee7b84"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitJoinPredicate (cyclomatic 42): LinqExpressionVisitors.visitJoinPredicate has cyclomatic complexity 42 (threshold 15). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Where every arm is uniform \u2014 the same kind of value, with no behaviour of its own \u2014 a table keyed by the case is the shorter form; wherever the arms carry different data or different behaviour, keep them as cases, because collapsing those trades an explicit, reviewable set of cases for nothing. This file is where this pass\u0027s cyclomatic complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 7 of the 10 methods over the threshold \u2014 including the worst \u2014 and 208 of the 229 points over it (91%), 14.9\u00D7 the next-largest file (src/SqlHydra.Query/SqlEmitterBase.fs at 14). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1425}}}],"partialFingerprints":{"codehealthFindingId/v1":"c106f27af05227611c0be1b7794d3227a81f61fdb21c9188a550cbe9369ce0e0"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitSqlFn (cyclomatic 40): LinqExpressionVisitors.visitSqlFn has cyclomatic complexity 40 (threshold 15). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Where every arm is uniform \u2014 the same kind of value, with no behaviour of its own \u2014 a table keyed by the case is the shorter form; wherever the arms carry different data or different behaviour, keep them as cases, because collapsing those trades an explicit, reviewable set of cases for nothing. This file is where this pass\u0027s cyclomatic complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 7 of the 10 methods over the threshold \u2014 including the worst \u2014 and 208 of the 229 points over it (91%), 14.9\u00D7 the next-largest file (src/SqlHydra.Query/SqlEmitterBase.fs at 14). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":634}}}],"partialFingerprints":{"codehealthFindingId/v1":"6c6ed98345ea36cb6b5c49486ca8ec965550d4cdd6254c2078166f4eb43e5298"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitHaving (cyclomatic 32): LinqExpressionVisitors.visitHaving has cyclomatic complexity 32 (threshold 15). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Where every arm is uniform \u2014 the same kind of value, with no behaviour of its own \u2014 a table keyed by the case is the shorter form; wherever the arms carry different data or different behaviour, keep them as cases, because collapsing those trades an explicit, reviewable set of cases for nothing. This file is where this pass\u0027s cyclomatic complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 7 of the 10 methods over the threshold \u2014 including the worst \u2014 and 208 of the 229 points over it (91%), 14.9\u00D7 the next-largest file (src/SqlHydra.Query/SqlEmitterBase.fs at 14). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1158}}}],"partialFingerprints":{"codehealthFindingId/v1":"b0900eae1a21e17e76f48398bc31e0c37f0a83c544bebafcfc2bca81a123f6a0"}},{"ruleId":"D1","level":"warning","message":{"text":"SqlEmitterBase.EmitSelectInto (cyclomatic 29): SqlEmitterBase.EmitSelectInto has cyclomatic complexity 29 (threshold 15). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Where every arm is uniform \u2014 the same kind of value, with no behaviour of its own \u2014 a table keyed by the case is the shorter form; wherever the arms carry different data or different behaviour, keep them as cases, because collapsing those trades an explicit, reviewable set of cases for nothing."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlEmitterBase.fs"},"region":{"startLine":261}}}],"partialFingerprints":{"codehealthFindingId/v1":"d008900dd5821076444827402d262a0543fc1d6e81b723e1d5f6b3b87e144a1a"}},{"ruleId":"D1","level":"warning","message":{"text":"SchemaTemplate.mkTable (cyclomatic 21): SchemaTemplate.mkTable has cyclomatic complexity 21 (threshold 15). To reduce it, separate the branches: extract each independent case into its own named function so the top-level body reads as a short sequence of named decisions."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SchemaTemplate.fs"},"region":{"startLine":80}}}],"partialFingerprints":{"codehealthFindingId/v1":"59b3815e37143b288b6503ed20a3daf4acee735eea9e80a5e28160e00122b64e"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitOrderByPropertySelector (cyclomatic 18): LinqExpressionVisitors.visitOrderByPropertySelector has cyclomatic complexity 18 (threshold 15). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Where every arm is uniform \u2014 the same kind of value, with no behaviour of its own \u2014 a table keyed by the case is the shorter form; wherever the arms carry different data or different behaviour, keep them as cases, because collapsing those trades an explicit, reviewable set of cases for nothing. This file is where this pass\u0027s cyclomatic complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 7 of the 10 methods over the threshold \u2014 including the worst \u2014 and 208 of the 229 points over it (91%), 14.9\u00D7 the next-largest file (src/SqlHydra.Query/SqlEmitterBase.fs at 14). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1308}}}],"partialFingerprints":{"codehealthFindingId/v1":"57f2eae9ca6f447b51152ffa39b2caa158ed12c4a1e1d71cba301737fca26440"}},{"ruleId":"D1","level":"warning","message":{"text":"TomlConfigParser.read (cyclomatic 16): TomlConfigParser.read has cyclomatic complexity 16 (threshold 15). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Where every arm is uniform \u2014 the same kind of value, with no behaviour of its own \u2014 a table keyed by the case is the shorter form; wherever the arms carry different data or different behaviour, keep them as cases, because collapsing those trades an explicit, reviewable set of cases for nothing."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/TomlConfigParser.fs"},"region":{"startLine":53}}}],"partialFingerprints":{"codehealthFindingId/v1":"194f59c06018e7ffd5aa666ef2069b43b91cbeb64b86f4d0c952aa84956bfdb5"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.sqlTypeForClrType (cyclomatic 16): LinqExpressionVisitors.sqlTypeForClrType has cyclomatic complexity 16 (threshold 15). To reduce it, split the body: these branches sit side by side rather than nested inside one another, so extracting each one on its own would leave a function per branch. Group the statements between the checks into named steps and move each step into its own function, so the body reads as a short sequence of named stages. This file is where this pass\u0027s cyclomatic complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 7 of the 10 methods over the threshold \u2014 including the worst \u2014 and 208 of the 229 points over it (91%), 14.9\u00D7 the next-largest file (src/SqlHydra.Query/SqlEmitterBase.fs at 14). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":62}}}],"partialFingerprints":{"codehealthFindingId/v1":"c76e78c85e159e7b193909e7688060c2a7648303debd0480031f0fb37096ba8a"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitWhere (cognitive 128): LinqExpressionVisitors.visitWhere has cognitive complexity 128 (threshold 15). Drivers by points: match/switch 25 (65 pts), if/else 21 (40 pts), boolean chains 14, error handling 3 (9 pts) (nesting depth added 65). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Keep every case explicit, and make the behaviour for cases you do not list a deliberate choice rather than an accident. This file is where this pass\u0027s cognitive complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 6 of the 12 methods over the threshold \u2014 including the worst \u2014 and 236 of the 289 points over it (82%), 11.2\u00D7 the next-largest file (src/SqlHydra.Query/QueryContext.fs at 21). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":768}}}],"partialFingerprints":{"codehealthFindingId/v1":"62af67555a9fa3a85e19d300935a415c3cb5787bbd2103e8692039f0e3c202f2"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitSelect (cognitive 67): LinqExpressionVisitors.visitSelect has cognitive complexity 67 (threshold 15). Drivers by points: match/switch 14 (37 pts), if/else 11 (18 pts), boolean chains 12 (nesting depth added 30). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Keep every case explicit, and make the behaviour for cases you do not list a deliberate choice rather than an accident. This file is where this pass\u0027s cognitive complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 6 of the 12 methods over the threshold \u2014 including the worst \u2014 and 236 of the 289 points over it (82%), 11.2\u00D7 the next-largest file (src/SqlHydra.Query/QueryContext.fs at 21). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1648}}}],"partialFingerprints":{"codehealthFindingId/v1":"8ce80b7f5f70509aee82fdbe4c98ccfd1ac77f04fb0c24373796d4d16fb3f587"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitJoinPredicate (cognitive 41): LinqExpressionVisitors.visitJoinPredicate has cognitive complexity 41 (threshold 15). Drivers by points: match/switch 10 (25 pts), error handling 4 (14 pts), boolean chains 2 (nesting depth added 25). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Keep every case explicit, and make the behaviour for cases you do not list a deliberate choice rather than an accident. This file is where this pass\u0027s cognitive complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 6 of the 12 methods over the threshold \u2014 including the worst \u2014 and 236 of the 289 points over it (82%), 11.2\u00D7 the next-largest file (src/SqlHydra.Query/QueryContext.fs at 21). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1425}}}],"partialFingerprints":{"codehealthFindingId/v1":"0e4469567224c6a86fc984fd4b6b605ebe1324849690ee892ea4feb6c62ab1ac"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitHaving (cognitive 40): LinqExpressionVisitors.visitHaving has cognitive complexity 40 (threshold 15). Drivers by points: if/else 10 (20 pts), match/switch 9 (19 pts), boolean chains 1 (nesting depth added 20). The drivers above price the dispatch low by construction \u2014 a dispatch is charged once however many cases it lists, while each branch inside an arm is charged in full \u2014 so most of this count is what the case bodies hold, and the arms are where it can be reduced. To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Keep every case explicit, and make the behaviour for cases you do not list a deliberate choice rather than an accident. This file is where this pass\u0027s cognitive complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 6 of the 12 methods over the threshold \u2014 including the worst \u2014 and 236 of the 289 points over it (82%), 11.2\u00D7 the next-largest file (src/SqlHydra.Query/QueryContext.fs at 21). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1158}}}],"partialFingerprints":{"codehealthFindingId/v1":"c9b518081324c95dcddaa08cbda4a81501cee198f7be1a32f5410a8ecbfe6762"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitSqlFn (cognitive 33): LinqExpressionVisitors.visitSqlFn has cognitive complexity 33 (threshold 15). Drivers by points: match/switch 8 (12 pts), boolean chains 8, if/else 4 (8 pts), loops 1 (3 pts), error handling 1 (2 pts) (nesting depth added 11). The drivers above price the dispatch low by construction \u2014 a dispatch is charged once however many cases it lists, while each branch inside an arm is charged in full \u2014 so most of this count is what the case bodies hold, and the arms are where it can be reduced. To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Keep every case explicit, and make the behaviour for cases you do not list a deliberate choice rather than an accident. This file is where this pass\u0027s cognitive complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 6 of the 12 methods over the threshold \u2014 including the worst \u2014 and 236 of the 289 points over it (82%), 11.2\u00D7 the next-largest file (src/SqlHydra.Query/QueryContext.fs at 21). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":634}}}],"partialFingerprints":{"codehealthFindingId/v1":"be825b8e843aeeb9cedd7a926fa594ee212a7e1ca6ebef2cedb7b0b8e740c4eb"}},{"ruleId":"D2","level":"warning","message":{"text":"QueryContext.PrepareInsertCommand (cognitive 27): QueryContext.PrepareInsertCommand has cognitive complexity 27 (threshold 15). Drivers by points: if/else 9 (20 pts), loops 2 (4 pts), match/switch 2 (3 pts) (nesting depth added 14). The drivers above price the dispatch low by construction \u2014 a dispatch is charged once however many cases it lists, while each branch inside an arm is charged in full \u2014 so most of this count is what the case bodies hold, and the arms are where it can be reduced. To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Keep every case explicit, and make the behaviour for cases you do not list a deliberate choice rather than an accident."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/QueryContext.fs"},"region":{"startLine":324}}}],"partialFingerprints":{"codehealthFindingId/v1":"ec0bd9b3c0373a03dc5eb6d80d75b1507f368e1f72e27cf0ecfac4e949438a8b"}},{"ruleId":"D2","level":"warning","message":{"text":"SchemaTemplate.mkTable (cognitive 26): SchemaTemplate.mkTable has cognitive complexity 26 (threshold 15). Drivers by points: if/else 8 (11 pts), match/switch 4 (7 pts), loops 4 (6 pts), boolean chains 2 (nesting depth added 8). To reduce it, split the body into named stages: move each independent step or branch into its own named function so the body reads as a short sequence of named calls rather than one long body."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SchemaTemplate.fs"},"region":{"startLine":80}}}],"partialFingerprints":{"codehealthFindingId/v1":"ffd3b0aaa5c7112417313060196fb8aaafea1fd288e5f4252bef1295f84d27d2"}},{"ruleId":"D2","level":"warning","message":{"text":"QueryContext.ReadReturningValues (cognitive 24): QueryContext.ReadReturningValues has cognitive complexity 24 (threshold 15). Drivers by points: if/else 11 (18 pts), match/switch 2 (4 pts), boolean chains 2 (nesting depth added 9). To reduce it, split the body into named stages: move each independent step or branch into its own named function so the body reads as a short sequence of named calls rather than one long body."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/QueryContext.fs"},"region":{"startLine":232}}}],"partialFingerprints":{"codehealthFindingId/v1":"0a969423feb0898be866854e1b7f3536b67efbdca7996d56017274f518a25ae7"}},{"ruleId":"D2","level":"warning","message":{"text":"SqlEmitterBase.EmitSelectInto (cognitive 24): SqlEmitterBase.EmitSelectInto has cognitive complexity 24 (threshold 15). Drivers by points: match/switch 7 (14 pts), if/else 9, loops 1 (nesting depth added 7). To reduce it, keep the dispatch but shrink the arms: move each non-trivial case body into its own named function (or onto the value being matched) so the dispatch reads one line per case, and group related cases into a sub-dispatch. Keep every case explicit, and make the behaviour for cases you do not list a deliberate choice rather than an accident."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlEmitterBase.fs"},"region":{"startLine":261}}}],"partialFingerprints":{"codehealthFindingId/v1":"5ba7786b29bbe790d9c3614bf908dbaddf5ece409d27128b52268cef5800582b"}},{"ruleId":"D2","level":"warning","message":{"text":"SchemaTemplate.generate (cognitive 21): SchemaTemplate.generate has cognitive complexity 21 (threshold 15). Drivers by points: if/else 8 (14 pts), loops 3 (5 pts), boolean chains 2 (nesting depth added 8). To reduce it, split the body into named stages: move each independent step or branch into its own named function so the body reads as a short sequence of named calls rather than one long body."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SchemaTemplate.fs"},"region":{"startLine":299}}}],"partialFingerprints":{"codehealthFindingId/v1":"bf0939db00baec3f7b11231491f5a001b1cf3e1d0a6fd44c898dd0cceea3d2a2"}},{"ruleId":"D2","level":"warning","message":{"text":"ColumnReadMethods.ConvertOracleProviderType (cognitive 21): ColumnReadMethods.ConvertOracleProviderType has cognitive complexity 21 (threshold 15). Drivers by points: if/else 16 (21 pts) (nesting depth added 5). To reduce it, split the body: most of this score is breadth rather than depth \u2014 checks laid out side by side rather than stacked \u2014 so group the statements between the checks into named steps and move each step into its own function. Some of it IS depth: where a check sits inside another whose only job is to reach it, merge the two into one condition, and where an else follows a branch that already returns, drop the trailing else and let the rest of the body continue at one level."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/Hydration.fs"},"region":{"startLine":45}}}],"partialFingerprints":{"codehealthFindingId/v1":"97d8cf5433ffde2e2169394b3fc1d5df4f4d8559f38efb1909e07d785ba0e4ef"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.sqlTypeForClrType (cognitive 17): LinqExpressionVisitors.sqlTypeForClrType has cognitive complexity 17 (threshold 15). Drivers by points: if/else 12, boolean chains 5. To reduce it, split the body: this score is breadth rather than depth \u2014 many checks laid out side by side rather than nested inside one another, so inverting conditions into early returns has nothing left to flatten. Group the statements between the checks into named steps and move each step into its own function, so the body reads as a short sequence of named stages. This file is where this pass\u0027s cognitive complexity CONCENTRATES: src/SqlHydra.Query/LinqExpressionVisitors.fs holds 6 of the 12 methods over the threshold \u2014 including the worst \u2014 and 236 of the 289 points over it (82%), 11.2\u00D7 the next-largest file (src/SqlHydra.Query/QueryContext.fs at 21). No single row can show this, because each is measured only against the threshold: reducing this one file moves this dimension further than any other file in the repository."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":62}}}],"partialFingerprints":{"codehealthFindingId/v1":"f9fe70e2a9ce046dbb2a2f5f10bada2a681fe2c35c723167e78f35a92187b2df"}},{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: SqlFn: TooManyMethods \u2014 137 methods. The bar is 30 methods; this is 107 over it, 4.57\u00D7 the bar. To reduce it, group the members that share the same data into a smaller type of their own and delegate to it, so no single type carries every responsibility."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/NpgsqlExtensions.fs"},"region":{"startLine":8}}}],"partialFingerprints":{"codehealthFindingId/v1":"4ce99b21cb771adf86f6df98fb82cee686c2361fe88d4620aa2dfcd2c102b5b2"}},{"ruleId":"D3","level":"warning","message":{"text":"FileTooLong: SqlHydra.Query/LinqExpressionVisitors.fs: FileTooLong \u2014 1428 significant lines (blank, comment-only and punctuation-only lines excluded), declaring 41 functions. The bar is 500 significant lines; this is 928 over it, 2.86\u00D7 the bar. To reduce it, split the file along the responsibilities already in it: move each cohesive group of declarations into its own sibling file in the same module or package, so no one file has to be read whole to change one of them."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"da0d498b34ddc2df761bd8e3dafbf6fc90d07fbf19b8eaa964276d718a4148fa"}},{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: SqlFn: TooManyMethods \u2014 77 methods. The bar is 30 methods; this is 47 over it, 2.57\u00D7 the bar. To reduce it, group the members that share the same data into a smaller type of their own and delegate to it, so no single type carries every responsibility."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/MySqlExtensions.fs"},"region":{"startLine":8}}}],"partialFingerprints":{"codehealthFindingId/v1":"d177edfe8842eaa8b30028405270164c43d1eed5b2034bb49f83acf127662d26"}},{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: SqlFn: TooManyMethods \u2014 59 methods. The bar is 30 methods; this is 29 over it, 1.97\u00D7 the bar. To reduce it, group the members that share the same data into a smaller type of their own and delegate to it, so no single type carries every responsibility."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/OracleExtensions.fs"},"region":{"startLine":8}}}],"partialFingerprints":{"codehealthFindingId/v1":"05f553a5ad51b6b03e93fef16c39ab75640861fe5983c45058abac878b336627"}},{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: SqlFn: TooManyMethods \u2014 47 methods. The bar is 30 methods; this is 17 over it, 1.57\u00D7 the bar. To reduce it, group the members that share the same data into a smaller type of their own and delegate to it, so no single type carries every responsibility."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlServerExtensions.fs"},"region":{"startLine":8}}}],"partialFingerprints":{"codehealthFindingId/v1":"5dc2623e7bc26af91087887e8b13c0c6267bbacbdf1b4375e99794788be36de9"}},{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: SqlFn: TooManyMethods \u2014 44 methods. The bar is 30 methods; this is 14 over it, 1.47\u00D7 the bar. To reduce it, group the members that share the same data into a smaller type of their own and delegate to it, so no single type carries every responsibility."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqliteExtensions.fs"},"region":{"startLine":8}}}],"partialFingerprints":{"codehealthFindingId/v1":"4b0649353a8b827bd9806dea351f396afe2afd21f865aafa532aad7785dd8439"}},{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: SelectBuilder\u00602: TooManyMethods \u2014 43 methods. The bar is 30 methods; this is 13 over it, 1.43\u00D7 the bar. To reduce it, group the members that share the same data into a smaller type of their own and delegate to it, so no single type carries every responsibility."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":112}}}],"partialFingerprints":{"codehealthFindingId/v1":"3a80145b81ce7031774aaf1c3e74e649abf56ed5581153d99994a617f9c7cb5f"}},{"ruleId":"D3","level":"warning","message":{"text":"FileTooLong: SqlHydra.Query/SelectBuilders.fs: FileTooLong \u2014 607 significant lines (blank, comment-only and punctuation-only lines excluded). The bar is 500 significant lines; this is 107 over it, 1.21\u00D7 the bar. To reduce it, split the file along the responsibilities already in it: move each cohesive group of declarations into its own sibling file in the same module or package, so no one file has to be read whole to change one of them."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"eca27a88ac5d67473dfb1065206a39940e5ab2e4490c2cfcbde35bd3d5509206"}},{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: QueryContext: TooManyMethods \u2014 34 methods. The bar is 30 methods; this is 4 over it, 1.13\u00D7 the bar. To reduce it, group the members that share the same data into a smaller type of their own and delegate to it, so no single type carries every responsibility."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/QueryContext.fs"},"region":{"startLine":19}}}],"partialFingerprints":{"codehealthFindingId/v1":"7a8ac9269fc41607e0a9bb82dafb3a86a7d92e6587e853112d6562196edaae4f"}},{"ruleId":"D3","level":"warning","message":{"text":"TooManyMethods: SqlEmitterBase: TooManyMethods \u2014 34 methods. The bar is 30 methods; this is 4 over it, 1.13\u00D7 the bar. To reduce it, group the members that share the same data into a smaller type of their own and delegate to it, so no single type carries every responsibility."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlEmitterBase.fs"},"region":{"startLine":24}}}],"partialFingerprints":{"codehealthFindingId/v1":"dec3f70d19706e300c33672a23bafc5110b395ae73bac3a444795a138bf42a51"}},{"ruleId":"D4","level":"warning","message":{"text":"Members sharing a duplicated core (5 members, 50\u002B identical tokens): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:1-142 | src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:1-260 | src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs:1-181 | src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:1-137 | src/SqlHydra.Cli/Sqlite/SqliteSchemaProvider.fs:1-250 \u2014 These 5 members share a duplicated core: a run of at least 50 identical tokens appears in every one of them. That run is NOT broken out as duplicated-block rows below \u2014 it is what admitted this row, and the blocks below cover only the part of it that clears the block floor, so they understate the correspondence. Read the members as one construct written 5 times. The repair is at the members\u0027 grain \u2014 factor the shared implementation out once and have all of them call it with their differences as parameters or as an injected step, or, where the difference is systematic, generate them from one template. Extracting the individual blocks below is not the same fix: it leaves every body in place and the next edit still has to be made 5 times."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"a63df865eaf0a77accf43a48bc50b3a7150e9fa879ff688607a81df05f6b3a8c"}},{"ruleId":"D4","level":"warning","message":{"text":"Edited copy of a member (103 corresponding lines): src/SqlHydra.Query/SqlServerExtensions.fs:1-135 | src/SqlHydra.Query/SqliteExtensions.fs:1-103 \u2014 These two members are one piece of code written twice and then edited apart: 103 consecutive lines correspond almost exactly, broken only by small local edits. Most of that correspondence is NOT reported as duplicated blocks below \u2014 the edits cut it into fragments and only the largest of them clear the block floor, so the rows below understate it. The repair is at the members\u0027 grain \u2014 factor the shared implementation into one the two call with their differences as parameters or as an injected step, or, where the difference is systematic (an extra return value, one transport against another), generate one from the other. Left alone, the next edit has to be made twice and the two will drift further apart."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlServerExtensions.fs"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"4e3ade369553b7924a3059fd967c42d591d2da94d5c8e0bf24d29fd4900d717a"}},{"ruleId":"D4","level":"warning","message":{"text":"Edited copy of a member (81 corresponding lines): src/SqlHydra.Query/MySqlExtensions.fs:1-94 | src/SqlHydra.Query/OracleExtensions.fs:1-81 \u2014 These two members are one piece of code written twice and then edited apart: 81 consecutive lines correspond almost exactly, broken only by small local edits. Most of that correspondence is NOT reported as duplicated blocks below \u2014 the edits cut it into fragments and only the largest of them clear the block floor, so the rows below understate it. The repair is at the members\u0027 grain \u2014 factor the shared implementation into one the two call with their differences as parameters or as an injected step, or, where the difference is systematic (an extra return value, one transport against another), generate one from the other. Left alone, the next edit has to be made twice and the two will drift further apart."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/MySqlExtensions.fs"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"db81c39261d51184054413a76d849745e41785a412c4ce9939e893c98396a607"}},{"ruleId":"D4","level":"warning","message":{"text":"Edited copies of one member (3 members, 52\u002B corresponding lines): src/SampleApp/DapperExample.fs:1-56 | src/SampleApp/DonaldExample.fs:1-57 | src/SampleApp/ReaderExample.fs:1-52 \u2014 These 3 members are one piece of code written 3 times and then edited apart: every two of them correspond over at least 52 lines, broken only by small local edits. Most of that correspondence is NOT reported as duplicated blocks below: the edits cut it into fragments and only the largest of them clear the block floor, so the rows below understate it. The repair is at the members\u0027 grain. Factor the shared implementation out once and have all of them call it with their differences as parameters or as an injected step, or, where the difference is systematic, generate them from one template. Left alone, the next edit has to be made 3 times and the copies will drift further apart."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SampleApp/DapperExample.fs"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"2e2c280aacc69deecf6b453ae1eea47095cebc3c675f03f6728f9db19f4faa56"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (49 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:729-777 | src/SqlHydra.Query/SelectBuilders.fs:828-876 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Query/SelectBuilders.fs:729\u0060 it runs out through the closing brace of the declaration holding it and carries on into the declaration that follows \u2014 the window is the tail of one member plus the head of the next, so no call can be substituted for those exact lines, and the smallest declaration that contains all of them is the type they sit in. The repeated unit is the member each site sits in: where those members\u0027 bodies are the same, move one whole member to the shared location and have the others delegate to it; where the copies are a run of near-identical overloads or wrappers that differ only in their signatures, the repetition IS the run \u2014 a one-line delegation has no helper inside it to lift \u2014 so generate the run from the set it enumerates, or accept it and keep each member\u0027s own documentation with it."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":729}}}],"partialFingerprints":{"codehealthFindingId/v1":"24d2d6ff2802068fc311b4dc827a69deedb2dd938b70eb506d890dedd0f78f19"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (41 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:813-853 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1172-1212 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":813}}}],"partialFingerprints":{"codehealthFindingId/v1":"28abc3a43a9f59bd42d7f34eb0d4d5d9a4b7fb376cb0fbe48a1e513e1af96143"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (34 lines \u00D7 4): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:105-138 | src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs:141-174 | src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:100-133 | src/SqlHydra.Cli/Sqlite/SqliteSchemaProvider.fs:212-245 \u2014 before extracting anything, compare \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs\u0060 and \u0060src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs\u0060 as WHOLE FILES: this scan already matched 4 separate duplicated blocks between them, totalling at least 67 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. The two sit in different directories, so one cannot simply be deleted in favour of the other while both are reached separately: hoist the shared part into a location both already depend on and have each file call it, and retire whichever file turns out to have no caller of its own left. Extracting one helper per block leaves the fork in place. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:105\u0060 it begins part-way through the construct above it, so those exact lines cannot be lifted as they stand \u2014 widen the region to the smallest complete statement or declaration that contains it, and extract that. \u2605 These copies have DRIFTED, and that is worth reading before extracting anything: just after the matched lines, \u0060src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs:175\u0060 calls \u0060filter\u0060 and \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:140\u0060 does not \u2014 after which the two agree again for 3 more lines. One of those two behaviours is the intended one and the other is what a copy-paste left behind, so decide which BEFORE unifying them: extracting the shared part will silently settle it, and if the copy that skips the call is the wrong one, that bug is already live."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":105}}}],"partialFingerprints":{"codehealthFindingId/v1":"7b201e3168b2869a92c366b36ff3afbff61bb0ea347cb4cfa6da91169dabbda9"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (20 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:403-422 | src/SqlHydra.Query/SelectBuilders.fs:452-471 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":403}}}],"partialFingerprints":{"codehealthFindingId/v1":"c12f903f5b581d86276fb00dfd5a443dea097305d4e56d993078c8e5752b850e"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (19 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:1538-1556 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1567-1585 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1538}}}],"partialFingerprints":{"codehealthFindingId/v1":"1179e6608e3ff828d968a3b155186405861e93a1750ad894ae22f71197d042ee"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (21\u201329 lines \u00D7 3): src/SqlHydra.Query/SelectBuilders.fs:367-387 | src/SqlHydra.Query/SelectBuilders.fs:414-442 | src/SqlHydra.Query/SelectBuilders.fs:463-489 \u2014 all 3 copies are in the same file, so extract the block into one function there and call it from every one of those sites \u2014 resolving only two of them leaves the rest to drift apart the first time one is edited. Note that the copies do not run to the end of the range shown: their LAST lines are different code, not the same code under different names \u2014 the matched region ends inside that line. Extract the lines above it, and read the last line of each site separately."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":367}}}],"partialFingerprints":{"codehealthFindingId/v1":"92499e668f8a8558ed41315968df10ce88afb2a9f8dd2d1b07f8e70d0f2bb32e"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (18 lines \u00D7 2): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:58-75 | src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:52-69 \u2014 before extracting anything, compare \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs\u0060 and \u0060src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs\u0060 as WHOLE FILES: this scan already matched 5 separate duplicated blocks between them, totalling at least 85 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. The two sit in different directories, so one cannot simply be deleted in favour of the other while both are reached separately: hoist the shared part into a location both already depend on and have each file call it, and retire whichever file turns out to have no caller of its own left. Extracting one helper per block leaves the fork in place. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:58\u0060 it runs out through the closing brace of the declaration holding it and carries on into the declaration that follows \u2014 the window is the tail of one member plus the head of the next, so no call can be substituted for those exact lines, and the smallest declaration that contains all of them is the type they sit in. The repeated unit is the member each site sits in: where those members\u0027 bodies are the same, move one whole member to the shared location and have the others delegate to it; where the copies are a run of near-identical overloads or wrappers that differ only in their signatures, the repetition IS the run \u2014 a one-line delegation has no helper inside it to lift \u2014 so generate the run from the set it enumerates, or accept it and keep each member\u0027s own documentation with it. \u2605 These copies have DRIFTED, and that is worth reading before extracting anything: just after the matched lines, \u0060src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:70\u0060 calls \u0060GetSchema\u0060, \u0060TryGetRestrictionsByKey\u0060 and \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:76\u0060 does not \u2014 after which the two agree again for 2 more lines. One of those two behaviours is the intended one and the other is what a copy-paste left behind, so decide which BEFORE unifying them: extracting the shared part will silently settle it, and if the copy that skips the call is the wrong one, that bug is already live."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":58}}}],"partialFingerprints":{"codehealthFindingId/v1":"fff42b7782f1395f3fe29f2a041ad9c3efed6c9b89baf28e5fb672c6b5f9249e"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (2\u201318 lines \u00D7 3): src/SqlHydra.Query/NpgsqlExtensions.fs:275-292 | src/SqlHydra.Query/SqlServerExtensions.fs:86-87 | src/SqlHydra.Query/SqliteExtensions.fs:85-99 \u2014 before extracting anything, compare \u0060src/SqlHydra.Query/NpgsqlExtensions.fs\u0060 and \u0060src/SqlHydra.Query/SqliteExtensions.fs\u0060 as WHOLE FILES: this scan already matched 3 separate duplicated blocks between them, totalling at least 54 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. If that is what happened, the fix is to keep one copy and have the other call it (or delete it), which resolves this row and its siblings together \u2014 extracting one helper per block leaves the fork in place. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Query/SqlServerExtensions.fs:86\u0060 it does not close everything it opens, so those exact lines cannot be lifted as they stand \u2014 widen the region to the smallest complete statement or declaration that contains it, and extract that. Note that the copies do not run to the end of the range shown: their LAST lines are different code, not the same code under different names \u2014 the matched region ends inside that line. Extract the lines above it, and read the last line of each site separately."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/NpgsqlExtensions.fs"},"region":{"startLine":275}}}],"partialFingerprints":{"codehealthFindingId/v1":"b64ed7f117e58ced429dfa7d6aa6c789e335112033a2eadf4488cf54739615ed"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (16 lines \u00D7 3): src/SqlHydra.Cli/MySql/MySqlDataTypes.fs:61-76 | src/SqlHydra.Cli/Npgsql/NpgsqlDataTypes.fs:67-82 | src/SqlHydra.Cli/SqlServer/SqlServerDataTypes.fs:56-71 \u2014 the copies span different directories, so extracting a shared function means choosing where it lives: put it somewhere all 3 call sites can already reach \u2014 a location they all depend on today, or a new shared one if there is none \u2014 and call it from each site; until then, every change has to be made 3 times. \u2605 These copies have DRIFTED, and that is worth reading before extracting anything: just before the matched lines, \u0060src/SqlHydra.Cli/SqlServer/SqlServerDataTypes.fs:47\u0060 calls \u0060Some\u0060 and \u0060src/SqlHydra.Cli/MySql/MySqlDataTypes.fs:58\u0060 does not \u2014 after which the two agree again for 3 more lines. One of those two behaviours is the intended one and the other is what a copy-paste left behind, so decide which BEFORE unifying them: extracting the shared part will silently settle it, and if the copy that skips the call is the wrong one, that bug is already live."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlDataTypes.fs"},"region":{"startLine":61}}}],"partialFingerprints":{"codehealthFindingId/v1":"3c8c173547b3646296d71b204582007f6ea6c9e68ce5ae4b46c2f599e3d07612"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (16 lines \u00D7 2): src/SampleApp/DapperExample.fs:41-56 | src/SampleApp/DonaldExample.fs:42-57 \u2014 the copies sit in sibling files of one directory, so a shared home is within easy reach: extract the block into a single shared function the call sites can all reach \u2014 a file they already depend on, or a new one alongside them \u2014 and call it from both call sites, so a change lands once. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SampleApp/DapperExample.fs:41\u0060 it runs out through the closing brace of the declaration holding it and carries on into the declaration that follows \u2014 the window is the tail of one member plus the head of the next, so no call can be substituted for those exact lines, and the smallest declaration that contains all of them is the type they sit in. The repeated unit is the member each site sits in: where those members\u0027 bodies are the same, move one whole member to the shared location and have the others delegate to it; where the copies are a run of near-identical overloads or wrappers that differ only in their signatures, the repetition IS the run \u2014 a one-line delegation has no helper inside it to lift \u2014 so generate the run from the set it enumerates, or accept it and keep each member\u0027s own documentation with it."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SampleApp/DapperExample.fs"},"region":{"startLine":41}}}],"partialFingerprints":{"codehealthFindingId/v1":"2a2d9601f811890cfb89fa3f2769f03fa369542454e66dc956d076c608befaae"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (12\u201313 lines \u00D7 5): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:122-133 | src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:239-251 | src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs:158-169 | src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:117-128 | src/SqlHydra.Cli/Sqlite/SqliteSchemaProvider.fs:229-240 \u2014 before extracting anything, compare \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs\u0060 and \u0060src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs\u0060 as WHOLE FILES: this scan already matched 4 separate duplicated blocks between them, totalling at least 67 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. The two sit in different directories, so one cannot simply be deleted in favour of the other while both are reached separately: hoist the shared part into a location both already depend on and have each file call it, and retire whichever file turns out to have no caller of its own left. Extracting one helper per block leaves the fork in place. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:122\u0060 it does not close everything it opens, so those exact lines cannot be lifted as they stand \u2014 widen the region to the smallest complete statement or declaration that contains it, and extract that. Note that the copies do not run to the end of the range shown: their LAST lines are different code, not the same code under different names \u2014 the matched region ends inside that line. Extract the lines above it, and read the last line of each site separately."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":122}}}],"partialFingerprints":{"codehealthFindingId/v1":"a47a456fe06be9bc986cb10bbb13969c650108b61ef6371ffb388e51233c4015"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (12\u201313 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:1329-1341 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1608-1619 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1329}}}],"partialFingerprints":{"codehealthFindingId/v1":"10d2e027037c6c20fb39d3df75a6e36d159db89f3140a309d3264a21389ca45b"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (11\u201312 lines \u00D7 2): src/SqlHydra.Query/SqlEmitterBase.fs:90-101 | src/SqlHydra.Query/SqlEmitterBase.fs:111-121 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited. Note that the copies do not run to the end of the range shown: their LAST lines are different code, not the same code under different names \u2014 the matched region ends inside that line. Extract the lines above it, and read the last line of each site separately."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlEmitterBase.fs"},"region":{"startLine":90}}}],"partialFingerprints":{"codehealthFindingId/v1":"785bb5128ca25599f47f6dcff628f89f29c13dc780b7dc64c3e9ea1e2bc6ceb1"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (9\u201311 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:1264-1272 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1472-1482 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1264}}}],"partialFingerprints":{"codehealthFindingId/v1":"a7e418f57189dbe2f1c25bd3cef5cabf8b8179349cabd905017be342bf5906d1"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (9 lines \u00D7 5): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:107-115 | src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:189-197 | src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs:143-151 | src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:102-110 | src/SqlHydra.Cli/Sqlite/SqliteSchemaProvider.fs:214-222 \u2014 before extracting anything, compare \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs\u0060 and \u0060src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs\u0060 as WHOLE FILES: this scan already matched 4 separate duplicated blocks between them, totalling at least 67 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. The two sit in different directories, so one cannot simply be deleted in favour of the other while both are reached separately: hoist the shared part into a location both already depend on and have each file call it, and retire whichever file turns out to have no caller of its own left. Extracting one helper per block leaves the fork in place. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:107\u0060 it does not close everything it opens, so those exact lines cannot be lifted as they stand \u2014 widen the region to the smallest complete statement or declaration that contains it, and extract that. \u2605 These copies have DRIFTED, and that is worth reading before extracting anything: just before the matched lines, \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:104\u0060 calls \u0060choose\u0060 and \u0060src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:188\u0060 does not \u2014 after which the two agree again for 2 more lines. One of those two behaviours is the intended one and the other is what a copy-paste left behind, so decide which BEFORE unifying them: extracting the shared part will silently settle it, and if the copy that skips the call is the wrong one, that bug is already live."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":107}}}],"partialFingerprints":{"codehealthFindingId/v1":"b192334d1e14e408ea889a198bd70cd52c43826a5bb4ab2c9a8519e8b7e40b69"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6\u20139 lines \u00D7 3): src/SqlHydra.Query/LinqExpressionVisitors.fs:769-777 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1159-1164 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1427-1432 \u2014 all 3 copies are in the same file, so extract the block into one function there and call it from every one of those sites \u2014 resolving only two of them leaves the rest to drift apart the first time one is edited. Note that the copies do not run to the end of the range shown: their LAST lines are different code, not the same code under different names \u2014 the matched region ends inside that line. Extract the lines above it, and read the last line of each site separately."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":769}}}],"partialFingerprints":{"codehealthFindingId/v1":"4a479da1cba225279fc83ec6c6a9a718af073396079313ede7fca150e05577c1"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (10 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:856-865 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1213-1222 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":856}}}],"partialFingerprints":{"codehealthFindingId/v1":"7985b29eaca2af9595b54887bac718dc93d819a968efb33ec378f3d69272edbe"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 3): src/SqlHydra.Query/LinqExpressionVisitors.fs:985-992 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1263-1270 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1471-1478 \u2014 all 3 copies are in the same file, so extract the block into one function there and call it from every one of those sites \u2014 resolving only two of them leaves the rest to drift apart the first time one is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":985}}}],"partialFingerprints":{"codehealthFindingId/v1":"2fdd318ab50db4991d2880ebd02763a0a71e738ff4cc4412805412357b19d6ba"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:1238-1245 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1440-1447 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1238}}}],"partialFingerprints":{"codehealthFindingId/v1":"c2bc5345fff929a098a1bcace78ce1fdab5c3536e4999186760715acc75eedb2"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (3\u20137 lines \u00D7 5): src/SqlHydra.Query/SqlEmitters.fs:83-89 | src/SqlHydra.Query/SqlEmitters.fs:140-146 | src/SqlHydra.Query/SqlEmitters.fs:176-182 | src/SqlHydra.Query/SqlEmitters.fs:228-234 | src/SqlHydra.Query/SqlEmitters.fs:242-244 \u2014 all 5 copies are in the same file, so extract the block into one function there and call it from every one of those sites \u2014 resolving only two of them leaves the rest to drift apart the first time one is edited. Note that the copies do not run to the end of the range shown: their LAST lines are different code, not the same code under different names \u2014 the matched region ends inside that line. Extract the lines above it, and read the last line of each site separately. \u2605 These copies have DRIFTED, and that is worth reading before extracting anything: just before the matched lines, \u0060src/SqlHydra.Query/SqlEmitters.fs:83\u0060 calls \u0060EmitInsert\u0060, \u0060EmitInsertCore\u0060 and \u0060src/SqlHydra.Query/SqlEmitters.fs:242\u0060 does not \u2014 after which the two agree again for 3 more lines. One of those two behaviours is the intended one and the other is what a copy-paste left behind, so decide which BEFORE unifying them: extracting the shared part will silently settle it, and if the copy that skips the call is the wrong one, that bug is already live."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlEmitters.fs"},"region":{"startLine":83}}}],"partialFingerprints":{"codehealthFindingId/v1":"93c66ef6610c6bae1df9e12a5be9176502641ca9d9b456f7cc173637b8ad7ec9"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Query/DeleteBuilders.fs:34-41 | src/SqlHydra.Query/UpdateBuilders.fs:106-113 \u2014 the copies sit in sibling files of one directory, so a shared home is within easy reach: extract the block into a single shared function the call sites can all reach \u2014 a file they already depend on, or a new one alongside them \u2014 and call it from both call sites, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/DeleteBuilders.fs"},"region":{"startLine":34}}}],"partialFingerprints":{"codehealthFindingId/v1":"cfd2d4ef0c19afa4cbfa7ae9faaf27ddd1dfeeb1e94cc5ce66c50c22fc7c3e88"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (31 lines \u00D7 2): src/SqlHydra.Query/NpgsqlExtensions.fs:256-286 | src/SqlHydra.Query/SqliteExtensions.fs:66-96 \u2014 before extracting anything, compare \u0060src/SqlHydra.Query/NpgsqlExtensions.fs\u0060 and \u0060src/SqlHydra.Query/SqliteExtensions.fs\u0060 as WHOLE FILES: this scan already matched 3 separate duplicated blocks between them, totalling at least 54 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. If that is what happened, the fix is to keep one copy and have the other call it (or delete it), which resolves this row and its siblings together \u2014 extracting one helper per block leaves the fork in place."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/NpgsqlExtensions.fs"},"region":{"startLine":256}}}],"partialFingerprints":{"codehealthFindingId/v1":"7b49803a50e3431af972f97acbf24933f99c9e91a7e84840bfedd54698855682"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:790-797 | src/SqlHydra.Query/SelectBuilders.fs:813-820 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Query/SelectBuilders.fs:790\u0060 it does not close everything it opens, so those exact lines cannot be lifted as they stand \u2014 widen the region to the smallest complete statement or declaration that contains it, and extract that."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":790}}}],"partialFingerprints":{"codehealthFindingId/v1":"e51c78537ba60cc7ab078c47724e2396babee32ce00ae52ccae4403b74026860"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:898-903 | src/SqlHydra.Query/LinqExpressionVisitors.fs:907-912 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":898}}}],"partialFingerprints":{"codehealthFindingId/v1":"f0c16ef8e4c8347b1be555ed90c189ce0a54f68d25616b3628ffe8292eb7f101"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:917-922 | src/SqlHydra.Query/LinqExpressionVisitors.fs:926-931 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":917}}}],"partialFingerprints":{"codehealthFindingId/v1":"cf6306aa113fc91ca7ebb930d8f92ad7f526067edc4e528ff707b0e7e7357d40"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:246-251 | src/SqlHydra.Query/SelectBuilders.fs:270-275 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":246}}}],"partialFingerprints":{"codehealthFindingId/v1":"8f9a81173432bceb55c02c46c7f7b41fb46ad83c1f85820bd66c32f7c34bd639"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:695-700 | src/SqlHydra.Query/SelectBuilders.fs:716-721 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Query/SelectBuilders.fs:695\u0060 it does not close everything it opens, so those exact lines cannot be lifted as they stand \u2014 widen the region to the smallest complete statement or declaration that contains it, and extract that."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":695}}}],"partialFingerprints":{"codehealthFindingId/v1":"8f5aeb522037be8e20d39cb54f308e76ea04cda17e6c1f2d83cc18ec33bcb2c5"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (5 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:972-977 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1242-1246 \u2014 both copies are in the same file, so extract the block into one function there and call it from each site \u2014 the copies drift apart the first time only one of them is edited."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":972}}}],"partialFingerprints":{"codehealthFindingId/v1":"149813350e68895ebc039bda6f7d25b27beca352ab9365663c2b559a1d057d69"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (5 lines \u00D7 2): src/SqlHydra.Query/MySqlExtensions.fs:51-55 | src/SqlHydra.Query/OracleExtensions.fs:43-47 \u2014 the copies sit in sibling files of one directory, so a shared home is within easy reach: extract the block into a single shared function the call sites can all reach \u2014 a file they already depend on, or a new one alongside them \u2014 and call it from both call sites, so a change lands once. \u2605 These copies have DRIFTED, and that is worth reading before extracting anything: just after the matched lines, \u0060src/SqlHydra.Query/MySqlExtensions.fs:58\u0060 calls \u0060CEILING\u0060 and \u0060src/SqlHydra.Query/OracleExtensions.fs:50\u0060 does not \u2014 after which the two agree again for 2 more lines. One of those two behaviours is the intended one and the other is what a copy-paste left behind, so decide which BEFORE unifying them: extracting the shared part will silently settle it, and if the copy that skips the call is the wrong one, that bug is already live."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/MySqlExtensions.fs"},"region":{"startLine":51}}}],"partialFingerprints":{"codehealthFindingId/v1":"d6c4fef15d09fb856fe4736ed1faffaa6585fa5a7604f690061fd87290c123b0"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (5 lines \u00D7 2): src/SqlHydra.Query/NpgsqlExtensions.fs:214-218 | src/SqlHydra.Query/SqliteExtensions.fs:37-41 \u2014 before extracting anything, compare \u0060src/SqlHydra.Query/NpgsqlExtensions.fs\u0060 and \u0060src/SqlHydra.Query/SqliteExtensions.fs\u0060 as WHOLE FILES: this scan already matched 3 separate duplicated blocks between them, totalling at least 54 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. If that is what happened, the fix is to keep one copy and have the other call it (or delete it), which resolves this row and its siblings together \u2014 extracting one helper per block leaves the fork in place. \u2605 These copies have DRIFTED, and that is worth reading before extracting anything: just before the matched lines, \u0060src/SqlHydra.Query/SqliteExtensions.fs:37\u0060 calls \u0060iif\u0060 and \u0060src/SqlHydra.Query/NpgsqlExtensions.fs:214\u0060 does not \u2014 after which the two agree again for 5 more lines. One of those two behaviours is the intended one and the other is what a copy-paste left behind, so decide which BEFORE unifying them: extracting the shared part will silently settle it, and if the copy that skips the call is the wrong one, that bug is already live."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/NpgsqlExtensions.fs"},"region":{"startLine":214}}}],"partialFingerprints":{"codehealthFindingId/v1":"58af804d469142b9ddd7346c0aa54022744bb5ae6c6262e4495dd0e50fe68380"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (12 lines \u00D7 3): src/SampleApp/DapperExample.fs:43-54 | src/SampleApp/DonaldExample.fs:44-55 | src/SampleApp/ReaderExample.fs:38-49 \u2014 the copies sit in sibling files of one directory, so a shared home is within easy reach: extract the block into a single shared function the call sites can all reach \u2014 a file they already depend on, or a new one alongside them \u2014 and call it from all 3 call sites, so a change lands once. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SampleApp/DapperExample.fs:43\u0060 it runs out through the closing brace of the declaration holding it and carries on into the declaration that follows \u2014 the window is the tail of one member plus the head of the next, so no call can be substituted for those exact lines, and the smallest declaration that contains all of them is the type they sit in. The repeated unit is the member each site sits in: where those members\u0027 bodies are the same, move one whole member to the shared location and have the others delegate to it; where the copies are a run of near-identical overloads or wrappers that differ only in their signatures, the repetition IS the run \u2014 a one-line delegation has no helper inside it to lift \u2014 so generate the run from the set it enumerates, or accept it and keep each member\u0027s own documentation with it."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SampleApp/DapperExample.fs"},"region":{"startLine":43}}}],"partialFingerprints":{"codehealthFindingId/v1":"1a0833e83354de85aef7fd235a9afede8ce8ba9393fa18da585f1ce8d2ea60d9"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (11 lines \u00D7 2): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:88-98 | src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:83-93 \u2014 before extracting anything, compare \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs\u0060 and \u0060src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs\u0060 as WHOLE FILES: this scan already matched 5 separate duplicated blocks between them, totalling at least 85 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. The two sit in different directories, so one cannot simply be deleted in favour of the other while both are reached separately: hoist the shared part into a location both already depend on and have each file call it, and retire whichever file turns out to have no caller of its own left. Extracting one helper per block leaves the fork in place. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:88\u0060 it runs out through the closing brace of the declaration holding it and carries on into the declaration that follows \u2014 the window is the tail of one member plus the head of the next, so no call can be substituted for those exact lines, and the smallest declaration that contains all of them is the type they sit in. The repeated unit is the member each site sits in: where those members\u0027 bodies are the same, move one whole member to the shared location and have the others delegate to it; where the copies are a run of near-identical overloads or wrappers that differ only in their signatures, the repetition IS the run \u2014 a one-line delegation has no helper inside it to lift \u2014 so generate the run from the set it enumerates, or accept it and keep each member\u0027s own documentation with it."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":88}}}],"partialFingerprints":{"codehealthFindingId/v1":"d4ca9db91428d421435745221ba1fa11bad2f9a95a1e7d500a9c3a3f65e5a434"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (11 lines \u00D7 2): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:33-43 | src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs:45-55 \u2014 before extracting anything, compare \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs\u0060 and \u0060src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs\u0060 as WHOLE FILES: this scan already matched 4 separate duplicated blocks between them, totalling at least 67 lines, which is the signature of one file having been copied from the other rather than of a helper waiting to be extracted. The two sit in different directories, so one cannot simply be deleted in favour of the other while both are reached separately: hoist the shared part into a location both already depend on and have each file call it, and retire whichever file turns out to have no caller of its own left. Extracting one helper per block leaves the fork in place."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":33}}}],"partialFingerprints":{"codehealthFindingId/v1":"b7a51a2602d64471f78e6b76e73cf779f72f4eacf87269625dc3362aaf29860f"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/SqlEmitterBase.fs:141-146 | src/SqlHydra.Query/SqlEmitters.fs:191-196 \u2014 the copies sit in sibling files of one directory, so a shared home is within easy reach: extract the block into a single shared function the call sites can all reach \u2014 a file they already depend on, or a new one alongside them \u2014 and call it from both call sites, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlEmitterBase.fs"},"region":{"startLine":141}}}],"partialFingerprints":{"codehealthFindingId/v1":"c34725b233b38c9ea94e591a00208485b6c51d0041dd84fa47f75a184dca9293"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (5 lines \u00D7 2): src/SqlHydra.Query/InsertBuilders.fs:94-98 | src/SqlHydra.Query/UpdateBuilders.fs:101-105 \u2014 the copies sit in sibling files of one directory, so a shared home is within easy reach: extract the block into a single shared function the call sites can all reach \u2014 a file they already depend on, or a new one alongside them \u2014 and call it from both call sites, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/InsertBuilders.fs"},"region":{"startLine":94}}}],"partialFingerprints":{"codehealthFindingId/v1":"fbf1817bba1ca7a4f90d742e313d005494c09ca0dbafdec9ede245f35bc3a336"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (5 lines \u00D7 3): src/SqlHydra.Query/MySqlExtensions.fs:13-17 | src/SqlHydra.Query/OracleExtensions.fs:11-15 | src/SqlHydra.Query/SqlServerExtensions.fs:12-16 \u2014 the copies sit in sibling files of one directory, so a shared home is within easy reach: extract the block into a single shared function the call sites can all reach \u2014 a file they already depend on, or a new one alongside them \u2014 and call it from all 3 call sites, so a change lands once. \u2605 These copies have DRIFTED, and that is worth reading before extracting anything: just before the matched lines, \u0060src/SqlHydra.Query/MySqlExtensions.fs:10\u0060 calls \u0060CHAR_LENGTH\u0060, \u0060CHARACTER_LENGTH\u0060 and \u0060src/SqlHydra.Query/OracleExtensions.fs:8\u0060 does not \u2014 after which the two agree again for 2 more lines. One of those two behaviours is the intended one and the other is what a copy-paste left behind, so decide which BEFORE unifying them: extracting the shared part will silently settle it, and if the copy that skips the call is the wrong one, that bug is already live."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/MySqlExtensions.fs"},"region":{"startLine":13}}}],"partialFingerprints":{"codehealthFindingId/v1":"807e91983ea232cde1abf39775a8873fbdee3cf9f60fd0b70bc85830ace2b93e"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Query/MySqlExtensions.fs:27-34 | src/SqlHydra.Query/SqlServerExtensions.fs:21-28 \u2014 the copies sit in sibling files of one directory, so a shared home is within easy reach: extract the block into a single shared function the call sites can all reach \u2014 a file they already depend on, or a new one alongside them \u2014 and call it from both call sites, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/MySqlExtensions.fs"},"region":{"startLine":27}}}],"partialFingerprints":{"codehealthFindingId/v1":"841baf0969b84aad6f2398226841e121e5df7f474c9b5310afb9c2f43f7424e9"}},{"ruleId":"D6","level":"warning","message":{"text":"Low cohesion: SelectBuilder\u00602 (LCOM4 14): SelectBuilder\u00602\u0027s methods fall into 14 groups that share no field and call none of each other, against a bar of more than 3 for this run (LCOM4, configurable \u2014 your repository\u0027s bar is the one quoted here). Each group is a set of methods reachable from one another through shared fields or direct calls, so 14 groups means the type has that many internally-connected clusters with nothing tying them together. Types whose shape makes a high count expected \u2014 and which would otherwise dominate this list \u2014 are excluded before this row is raised, so this is a genuine split candidate rather than a metric reading. It is still a shape, not a defect: confirm the groups match responsibilities you can name before splitting."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":112}}}],"partialFingerprints":{"codehealthFindingId/v1":"20a2fb13a8319cc280ee1fb9a0bf0baba3261fd0364d3d7d8cd5a3f4b3817861"}},{"ruleId":"D6","level":"warning","message":{"text":"Low cohesion: SqlServerEmitter (LCOM4 4): SqlServerEmitter\u0027s methods fall into 4 groups that share no field and call none of each other, against a bar of more than 3 for this run (LCOM4, configurable \u2014 your repository\u0027s bar is the one quoted here). Each group is a set of methods reachable from one another through shared fields or direct calls, so 4 groups means the type has that many internally-connected clusters with nothing tying them together. Types whose shape makes a high count expected \u2014 and which would otherwise dominate this list \u2014 are excluded before this row is raised, so this is a genuine split candidate rather than a metric reading. It is still a shape, not a defect: confirm the groups match responsibilities you can name before splitting."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlEmitters.fs"},"region":{"startLine":9}}}],"partialFingerprints":{"codehealthFindingId/v1":"dbc6a3cb39efd5556951611c4ef25d702b2e0bf1e8bf6a5831b1c44c86d0b10d"}},{"ruleId":"D14","level":"error","message":{"text":"Banned license: MySql.Data: \u0060MySql.Data\u0060 9.0.0 resolves to SPDX id GPL-2.0-only, and this run\u0027s banned set is AGPL-3.0, GPL-2.0, GPL-3.0, LGPL-3.0. The id is read as an SPDX expression: an \u0060OR\u0060 is a choice and is charged only when every branch is banned, an \u0060AND\u0060 binds every operand, and a \u0060WITH\u0060 exception leaves the licence it attaches to as it is. Each licence id is then matched as a SUBSTRING that starts at a token boundary, not an exact comparison \u2014 which is how variants like \u0060-only\u0060 and \u0060-or-later\u0060 are caught while \u0060LGPL-2.0-only\u0060 is not read as \u0060GPL-2.0\u0060, and it is the rule to apply if you re-check this by hand. The set is policy, not law: it is configurable, so a licence banned here may be acceptable in your context, and the row is then something to record an exception for rather than to fix. \u2605 This arm reads the resolved package list and knows nothing about dependency SCOPE \u2014 it cannot tell a runtime dependency from a build- or test-only one, so unlike the Bundler arm it is NOT claiming this ships to your users. Check where it sits before acting. \u2605 DEPTH: this repository\u0027s MSBuild projects declare 27 direct \u0060PackageReference\u0060(s), and 223 further package(s) were reached beyond them by closing the graph over nuget.org\u0027s own nuspec dependency graph \u2014 so a banned licence pulled in only by a dependency\u0027s OWN dependencies is inside this verdict. A package whose licence nuget.org could not be asked for is not graded, and version ranges are taken at their lower bound, so this is the closure as that graph states it rather than a restored consumer\u0027s exact resolution."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SqlHydra.Cli.fsproj"},"region":{"startLine":60}}}],"partialFingerprints":{"codehealthFindingId/v1":"2fec91cb4b6a7dff508f29bfbf94cea9c8f4ddf3e91586b2f2505bab571a2547"}},{"ruleId":"D15","level":"warning","message":{"text":"Hotspot: src/SqlHydra.Query/LinqExpressionVisitors.fs: src/SqlHydra.Query/LinqExpressionVisitors.fs changed 18 times in last 90 days, max cyclomatic complexity 108 in LinqExpressionVisitors.visitWhere at line 768. 1 of those changes was a fix/bug commit, and the other 17 changed it for other reasons \u2014 this file is under both repair and feature pressure. Before the next change lands here, make sure the area it touches is under test, then split that area out of the file so the following change is smaller than this one \u2014 a file this often edited pays the complexity back every time. Counted over 2026-07-21..2026-10-19, the 90 days ending at the analysed commit. Reproduce with \u0060git log --since=\u00272026-07-21 02:41:19 -04:00\u0027 --until=\u00272026-10-19 02:41:19 -04:00\u0027 --full-history --no-merges -- src/SqlHydra.Query/LinqExpressionVisitors.fs\u0060: merges are excluded because a merge re-states changes already counted at their own commits, and history is NOT path-simplified because a change that reached the file through a merged branch is still a change to it. That command counts raw commits and can read HIGHER than this row, which counts a cherry-picked re-land, and a revert together with the commit it undoes, once each \u2014 a difference of several commits on a file whose history was re-landed or reverted inside the window."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":768}}}],"partialFingerprints":{"codehealthFindingId/v1":"3784ec8174d20575ee26d3771c43506db473301818efb588ad3666f5247ad160"}},{"ruleId":"D15","level":"warning","message":{"text":"Hotspot: src/SqlHydra.Cli/SchemaTemplate.fs: src/SqlHydra.Cli/SchemaTemplate.fs changed 8 times in last 90 days, max cyclomatic complexity 21 in SchemaTemplate.mkTable at line 80. Frequent change and high complexity in one file compound: schedule the next change to it to include carving out the part being edited, with the area under test before it moves. Counted over 2026-07-21..2026-10-19, the 90 days ending at the analysed commit. Reproduce with \u0060git log --since=\u00272026-07-21 02:41:19 -04:00\u0027 --until=\u00272026-10-19 02:41:19 -04:00\u0027 --full-history --no-merges -- src/SqlHydra.Cli/SchemaTemplate.fs\u0060: merges are excluded because a merge re-states changes already counted at their own commits, and history is NOT path-simplified because a change that reached the file through a merged branch is still a change to it. That command counts raw commits and can read HIGHER than this row, which counts a cherry-picked re-land, and a revert together with the commit it undoes, once each \u2014 a difference of several commits on a file whose history was re-landed or reverted inside the window."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SchemaTemplate.fs"},"region":{"startLine":80}}}],"partialFingerprints":{"codehealthFindingId/v1":"d7995fee7a5d8bfe56afd223fed1e2b4b179b552c1e968aedd4f3a442948d808"}},{"ruleId":"D15","level":"warning","message":{"text":"Hotspot: src/SqlHydra.Cli/TomlConfigParser.fs: src/SqlHydra.Cli/TomlConfigParser.fs changed 3 times in last 90 days, max cyclomatic complexity 16 in TomlConfigParser.read at line 53. Frequent change and high complexity in one file compound: schedule the next change to it to include carving out the part being edited, with the area under test before it moves. Counted over 2026-07-21..2026-10-19, the 90 days ending at the analysed commit. Reproduce with \u0060git log --since=\u00272026-07-21 02:41:19 -04:00\u0027 --until=\u00272026-10-19 02:41:19 -04:00\u0027 --full-history --no-merges -- src/SqlHydra.Cli/TomlConfigParser.fs\u0060: merges are excluded because a merge re-states changes already counted at their own commits, and history is NOT path-simplified because a change that reached the file through a merged branch is still a change to it. That command counts raw commits and can read HIGHER than this row, which counts a cherry-picked re-land, and a revert together with the commit it undoes, once each \u2014 a difference of several commits on a file whose history was re-landed or reverted inside the window."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/TomlConfigParser.fs"},"region":{"startLine":53}}}],"partialFingerprints":{"codehealthFindingId/v1":"97a8186e939575b1c64eff4fa78c7438075cd0df0ba806d78ddd9856e179a722"}},{"ruleId":"D20","level":"note","message":{"text":"No ADRs found: No ADRs found. No recognised ADR directory (\u0060docs/adr/\u0060, \u0060docs/decisions/\u0060, \u0060adr/\u0060, \u0060docs/rfcs/\u0060, an \u0060ADR0001/\u0060 folder, or their siblings) exists anywhere in this tree. What was searched, so you can tell an empty log from a search that missed one: every directory under the tree (build output, dependencies and VCS metadata excepted), for a document that is either any non-index page inside a recognised ADR directory, whatever its name and however deeply nested (\u0060docs/adr/use-postgres.md\u0060, \u0060docs/adr/2024/0001-x.md\u0060); or a file anywhere whose name is ADR-shaped (\u00600001-use-postgres.md\u0060, \u0060adr-012-caching.md\u0060); or, when neither turned anything up, a document carrying the decision-record signature (an \u0022Architecture Decision Record\u0022 heading, or Status / Context / Decision / Consequences as section headings). A decision log that clears none of these \u2014 unnumbered files outside any recognised directory, without those headings \u2014 is not seen by this check and this row is then wrong. If that is your case, say so rather than renaming anything; otherwise, consider recording architectural decisions in \u0060docs/adr/\u0060. ADRs are expected here because \u0060src/SqlHydra.Cli/SqlHydra.Cli.fsproj\u0060 makes this repository a deployable product (line 4)."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SqlHydra.Cli.fsproj"},"region":{"startLine":4}}}],"partialFingerprints":{"codehealthFindingId/v1":"0d31611efa11e766b2af513840b3cf9fdd13e8eabc9c85ccbe599b2a39d1de57"}},{"ruleId":"D26","level":"note","message":{"text":"Projects may be oversized for their cohesion: 1 of 5 project(s) overshoot their size bounds, lowering Project Cohesion to 7.9/10. The most over is \u0060src/SqlHydra.Query\u0060 (6225 LoC, 126 module-visible types across 1 directories). Review these for cohesion \u2014 draw the boundary inside the module first (group each responsibility into its own package or directory and keep the cross-boundary members non-public), since splitting a published package moves types between packages and breaks consumers."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"d5a94650dc74886a0f1f08eb9fb6775f1fc395279ef7e901c970c9d26f767a72"}},{"ruleId":"D29","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"80f3fcb89b907f5b73950b4a7860aeff7a53b4d8199be26edc71eb1ef3ef8035"},"taxa":[{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-353","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}}]},{"ruleId":"D29","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"afd518d342cf1158b4db19052d0cfec4dc14c33dca65afc1636d9b800cb623d5"},"taxa":[{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-353","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}}]},{"ruleId":"D29","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"0368062220b7d03a1fa9e9d2bccb854d86c67fc9ecc0cc9ff48703e4ad75233a"},"taxa":[{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-353","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}}]},{"ruleId":"D29","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"4605d90208aa912f686365b6f14debdbcc499c88d697f0cbfb5b0cc49f87e4d2"},"taxa":[{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-353","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}}]},{"ruleId":"D29","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"fcc53031fa987d6bc5a5b08489e3381c86035392521a66ecd56088c20fcbe155"},"taxa":[{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-353","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}}]},{"ruleId":"D30","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"c3e6c10c115b57ff13e2c6ecffdcfba0f101bfd55dda1c77353120af7b930b5e"},"properties":{"dependency":{"package":"NuGet.Packaging","version":"5.11.0","advisory":"[GHSA redacted]","aliases":["[GHSA redacted]"],"reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"1f79a595d62add568feda19f54d04fdad0273f072ae213a4e4ad714127a8a2fe"},"properties":{"dependency":{"package":"System.Drawing.Common","version":"4.7.0","advisory":"[GHSA redacted]","reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"a0513ee2b90f9702d9b20d1cca8a9f81256266aa18ae9b68f36a6a23179e8547"},"properties":{"dependency":{"package":"Microsoft.Build.Tasks.Core","version":"16.10.0","advisory":"[GHSA redacted]","reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"14d8fa5b374706f2a23b008484ae491b6498dedf4e25e13a0f4f0850a7c57e1f"},"properties":{"dependency":{"package":"NuGet.Common","version":"5.11.0","advisory":"[GHSA redacted]","reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"e7d2399cf8cdde587b4d04ba5a89a2fb68eba8093c394245fe81776742335139"},"properties":{"dependency":{"package":"NuGet.Protocol","version":"5.11.0","advisory":"[GHSA redacted]","aliases":["[GHSA redacted]","[GHSA redacted]"],"reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"error","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"d246d75b65523bf2d2a40511b99aa4a99c398d84dce0bc89395442294f995af5"},"properties":{"dependency":{"package":"SQLitePCLRaw.lib.e_sqlite3","version":"2.1.11","advisory":"[GHSA redacted]","reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"warning","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"de0152212ca8b0d3aa7654014e44d070de785c3d7870950658b1a178eece01d2"},"properties":{"dependency":{"package":"System.Security.Cryptography.Xml","version":"4.7.0","advisory":"[GHSA redacted]","reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"warning","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"edff0eaff91b3d61fcab9e8ce8b0dea7b4ef174aeac579c5d0541650fe61401d"},"properties":{"dependency":{"package":"Microsoft.Rest.ClientRuntime","version":"2.3.20","advisory":"[GHSA redacted]","reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"warning","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"75453fd52e6c1baac9c10bb20f64fa02c1f7b6ca3d3a8f9bad6e58cafd89f97e"},"properties":{"dependency":{"package":"Azure.Identity","version":"1.11.3","advisory":"[GHSA redacted]","reachability":{"kind":"unknown"}}}},{"ruleId":"D30","level":"warning","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"f89ff1a14180b6256c3e54bc34a482978ba13b6bd5d221a7cc88c349f3769eb5"},"properties":{"dependency":{"package":"Microsoft.Identity.Client","version":"4.60.3","advisory":"[GHSA redacted]","reachability":{"kind":"unknown"}}}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"58d4d575c2773a22e7ce1c3824212251512bb64b539fa5b482e2a205d4309427"},"taxa":[{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-353","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}}]},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"9c8d8bb5d54049393618e5642965543eb6309dcf62185d769fe0794ee75688b5"},"taxa":[{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-353","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}}]},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"afa0b0818a06390e9cd05fb93708c72eb7dbec188c9fa835da6b729da202e2ae"}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"95a988d7c3343699cbbef9979078a818bd3191489b2f8a00258931d46634815f"},"taxa":[{"id":"CWE-1357","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-353","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"A03:2025","toolComponent":{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61"}}]},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"fa05377439dbe2497b22ffd781f8356586e7c79ac24a13eb53133a71eef059f3"}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"d969bca851f432bee1f77b7d75f6e22e389ecf6a119abb94e9b2ea1432bd38e8"}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"648294b41a71c1e2371eeb6445259e3d25404d1898163e88a11ed74dd67e6719"}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"734ff3d75ee22f4b9f318ec2878dbba3a3b4d45a49012cf3e511db40a63faf41"}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"b6c10a100a8c6ea843f32a3d9b328389d02bb129721a79787a721994e852b450"}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"071c8012ec13f46cf914fe2e82770a0bb1765bca9962dce8a6fb1eef8b2d59ec"}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"456a48ca408a6bd62330da4e2c41c68b77f415e86ccafe448479ffcebb031cb4"}},{"ruleId":"D31","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"2d8afc51f741dd8f12fa0daed99cd4d0b51495e5537af4a112810adff59406f0"}},{"ruleId":"D36","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"1b213f6eedd4b140d0bc37bdf1496f72811a643f34064f12518b32e9e83bcfc7"},"taxa":[{"id":"CICD-SEC-9","toolComponent":{"name":"OWASP Top 10 CI/CD Security Risks","guid":"3c9b2a6e-5d14-4f7b-8e02-6a1d9c4b7f35"}}]},{"ruleId":"D36","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"0e17f71490e4d120a48b2b2881ab866c93b272bef2febb673a3e8e42b2c288ab"},"taxa":[{"id":"CICD-SEC-9","toolComponent":{"name":"OWASP Top 10 CI/CD Security Risks","guid":"3c9b2a6e-5d14-4f7b-8e02-6a1d9c4b7f35"}}]},{"ruleId":"D36","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"eb00976a698a5d68999b7ee6d27206fd374e916853e7ff1ead5eed42386f043f"},"taxa":[{"id":"CICD-SEC-9","toolComponent":{"name":"OWASP Top 10 CI/CD Security Risks","guid":"3c9b2a6e-5d14-4f7b-8e02-6a1d9c4b7f35"}}]},{"ruleId":"D36","level":"warning","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"90f83b4fa27db32740afe9540c905f3c0499caed87f61049a8a903ecc95b41c3"},"taxa":[{"id":"CICD-SEC-8","toolComponent":{"name":"OWASP Top 10 CI/CD Security Risks","guid":"3c9b2a6e-5d14-4f7b-8e02-6a1d9c4b7f35"}}]},{"ruleId":"D36","level":"warning","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"1eaa8183e815dc873e7711cbf3da06427a0c98fb15b9dacbadac99225a249a9f"},"taxa":[{"id":"CICD-SEC-4","toolComponent":{"name":"OWASP Top 10 CI/CD Security Risks","guid":"3c9b2a6e-5d14-4f7b-8e02-6a1d9c4b7f35"}}]},{"ruleId":"D36","level":"note","message":{"text":"A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."},"partialFingerprints":{"codehealthFindingId/v1":"ace515990e7ee0f17b5c17e44dd168a5bdecf90804a3a3dd845cf05540978013"},"taxa":[{"id":"CICD-SEC-3","toolComponent":{"name":"OWASP Top 10 CI/CD Security Risks","guid":"3c9b2a6e-5d14-4f7b-8e02-6a1d9c4b7f35"}}]},{"ruleId":"GD1","level":"warning","message":{"text":"Unfinished stub \u2014 raises a \u0022not implemented\u0022 error: A shipped binding\u0027s whole body still raises a \u0022not implemented\u0022 error \u2014 generated scaffolding that was never completed. Implement it or remove the dead surface."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":8}}}],"partialFingerprints":{"codehealthFindingId/v1":"a062abb30ad9e75395624c3d7029d7dac0d55fdcbd20cc1df798ad3e5439849a"}},{"ruleId":"GD1","level":"warning","message":{"text":"Unfinished stub \u2014 raises a \u0022not implemented\u0022 error: A shipped binding\u0027s whole body still raises a \u0022not implemented\u0022 error \u2014 generated scaffolding that was never completed. Implement it or remove the dead surface."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/QuotationVisitor.fs"},"region":{"startLine":7}}}],"partialFingerprints":{"codehealthFindingId/v1":"75195ef343711aff4d455f92e3a6bdc8d48c0025f6924852215151ff2836c687"}},{"ruleId":"M2","level":"note","message":{"text":"No ADRs: No Architecture Decision Records found \u2014 no conventional ADR directory, no numbered \u0060NNNN-title\u0060 documents in any markup this check reads, and nothing ADR-shaped by content. Design rationale recorded elsewhere (a design-notes tree, a mailing list, pull-request discussion) is not visible to this check and is not re-findable per decision, so a future maintainer cannot ask why one choice was made and get an answer."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"670b3d6e36a756d63097d0dfbf90afd5fc761308800b9354894a07c3f4e4aa14"}},{"ruleId":"P2","level":"warning","message":{"text":"No structured logging: No logging or diagnostics emission found. This repository ships a binary its users launch rather than a service you operate, so there is no operator to page \u2014 but when a run fails on a user\u0027s machine, neither they nor you have anything to read."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"9f10d71351c6778ebe84e761f82a90d4f9ed6c64f5e01975ede8fda7e4e2ebc5"}},{"ruleId":"P3","level":"note","message":{"text":"No SAST: No static application security testing detected. For this repository\u0027s stack, add \u0060semgrep --config=auto\u0060 plus gitleaks for committed secrets (F# is not a CodeQL language and has no language-specific SAST engine) as a CI step. What was searched, so you can tell an absence from a miss: the 2 CI workflow file(s) in this repository, and the scanner and linter configuration checked in beside them. A scan that runs outside CI, one configured in your forge\u0027s web UI rather than in a committed file, or a tool whose name is none of those this check carries, is not seen \u2014 if that is your case the row is wrong, and saying so is more useful than adding a second scanner."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":".github/workflows/build-and-test.yml"},"region":{"startLine":9}}}],"partialFingerprints":{"codehealthFindingId/v1":"6e54424179c892f03ef2fd003130ac4bd43f39bbf3b1ca0a0143e25acb80ec87"}},{"ruleId":"P3","level":"note","message":{"text":"No dependency-update automation: \u0060src/Build/Build.fsproj\u0060 declares packages, and nothing in the repository keeps them current: no Dependabot or Renovate configuration that schedules updates, and no dependency-review gate on pull requests. A pinned dependency stays at the version it was added at until someone notices \u2014 including after an advisory is published against it. Add a \u0060.github/dependabot.yml\u0060 with one \u0060package-ecosystem\u0060 entry per ecosystem the tree uses (or an enabled \u0060renovate.json\u0060), and gate pull requests with \u0060actions/dependency-review-action\u0060."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/Build/Build.fsproj"},"region":{"startLine":17}}}],"partialFingerprints":{"codehealthFindingId/v1":"6ab6072b4bcc1b46c821194ac925b0abf22dae0a15f7aa3b70b0a69377765d81"}},{"ruleId":"P6","level":"note","message":{"text":"No changelog: No CHANGELOG/HISTORY/RELEASES file \u2014 what shipped when isn\u0027t easy to reconstruct for support or audit. (Versioning/tagging makes releases traceable, but a changelog records the what.)"},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"dda5aa5aed8cbb292c3ef2b733bc138f614293ae6426c85e98bf31ef330d9415"}},{"ruleId":"SC1","level":"warning","message":{"text":"NuGet dependencies are not locked: No packages.lock.json and no central package management \u2014 restores aren\u0027t reproducible or pinned (SSDF PW.4.4). Enable \u003CRestorePackagesWithLockFile\u003Etrue\u003C/RestorePackagesWithLockFile\u003E (commit the lockfile) or adopt Directory.Packages.props. Advisory \u2014 never scored."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"0a97b4f69ccac509400ece7eedefb06d3ede0522cd4d8bcb5c068bea719545a6"}},{"ruleId":"X10","level":"note","message":{"text":"Duplicated predicate: \u0060hasMore \u0026\u0026 not cancel.IsCancellationRequested\u0060 appears character-identically in 2 files \u2014 src/SqlHydra.Query/QueryContext.fs, src/SqlHydra.Query/SelectBuilders.fs. It is one line, so the duplication detector\u0027s token window never sees it; the copies drift when only one is corrected. Give the condition a name and one home."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/QueryContext.fs"},"region":{"startLine":206}}}],"partialFingerprints":{"codehealthFindingId/v1":"5172c90aab5d71f4ca8bf421e24c762bce00b91ad9690864d48717958bb97ed0"}}],"taxonomies":[{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d","organization":"MITRE","informationUri":"https://cwe.mitre.org/","isComprehensive":false,"shortDescription":{"text":"The MITRE Common Weakness Enumeration (CWE)."},"taxa":[{"id":"CWE-1032","guid":"5f21e517-68aa-a650-9a25-5771ef024637","name":"OWASP Top Ten \u2014 Security Misconfiguration category","shortDescription":{"text":"OWASP Top Ten \u2014 Security Misconfiguration category"},"helpUri":"https://cwe.mitre.org/data/definitions/1032.html"},{"id":"CWE-1357","guid":"e4d2e772-757e-0a5c-bd7d-77052949d866","name":"Reliance on Insufficiently Trustworthy Component","shortDescription":{"text":"Reliance on Insufficiently Trustworthy Component"},"helpUri":"https://cwe.mitre.org/data/definitions/1357.html"},{"id":"CWE-1395","guid":"800e09e7-c11a-8654-9fa6-86f398995fed","name":"Dependency on Vulnerable Third-Party Component","shortDescription":{"text":"Dependency on Vulnerable Third-Party Component"},"helpUri":"https://cwe.mitre.org/data/definitions/1395.html"},{"id":"CWE-16","guid":"659db3ea-affc-8453-8add-c1218fbfcb92","name":"Configuration","shortDescription":{"text":"Configuration"},"helpUri":"https://cwe.mitre.org/data/definitions/16.html"},{"id":"CWE-259","guid":"ae9ad959-fbb6-9d5e-892d-3dca66da0b69","name":"Use of Hard-coded Password","shortDescription":{"text":"Use of Hard-coded Password"},"helpUri":"https://cwe.mitre.org/data/definitions/259.html"},{"id":"CWE-353","guid":"09d7e902-d4ee-f05d-ae6c-0a1554d0c18f","name":"Missing Support for Integrity Check","shortDescription":{"text":"Missing Support for Integrity Check"},"helpUri":"https://cwe.mitre.org/data/definitions/353.html"},{"id":"CWE-494","guid":"b8a65e0d-e459-4a55-a931-fc1136482375","name":"Download of Code Without Integrity Check","shortDescription":{"text":"Download of Code Without Integrity Check"},"helpUri":"https://cwe.mitre.org/data/definitions/494.html"},{"id":"CWE-506","guid":"401d6455-56e3-0552-9a39-f77461673e3f","name":"Embedded Malicious Code","shortDescription":{"text":"Embedded Malicious Code"},"helpUri":"https://cwe.mitre.org/data/definitions/506.html"},{"id":"CWE-732","guid":"1da27e8f-b330-7650-ab63-bd61953eae5d","name":"Incorrect Permission Assignment for Critical Resource","shortDescription":{"text":"Incorrect Permission Assignment for Critical Resource"},"helpUri":"https://cwe.mitre.org/data/definitions/732.html"},{"id":"CWE-77","guid":"332c8ade-6612-9f56-a06b-d8d90b1a8750","name":"Improper Neutralization of Special Elements used in a Command (\u0027Command Injection\u0027)","shortDescription":{"text":"Improper Neutralization of Special Elements used in a Command (\u0027Command Injection\u0027)"},"helpUri":"https://cwe.mitre.org/data/definitions/77.html"},{"id":"CWE-78","guid":"2e31ceaf-c7ae-2e5e-9661-cfb1362789cf","name":"Improper Neutralization of Special Elements used in an OS Command (\u0027OS Command Injection\u0027)","shortDescription":{"text":"Improper Neutralization of Special Elements used in an OS Command (\u0027OS Command Injection\u0027)"},"helpUri":"https://cwe.mitre.org/data/definitions/78.html"},{"id":"CWE-79","guid":"fd45580b-e8c4-fc5e-8c2f-aa8fab0b4dbf","name":"Improper Neutralization of Input During Web Page Generation (\u0027Cross-site Scripting\u0027)","shortDescription":{"text":"Improper Neutralization of Input During Web Page Generation (\u0027Cross-site Scripting\u0027)"},"helpUri":"https://cwe.mitre.org/data/definitions/79.html"},{"id":"CWE-798","guid":"5e8f057d-fee3-995a-a0cb-9fc5b0d174d1","name":"Use of Hard-coded Credentials","shortDescription":{"text":"Use of Hard-coded Credentials"},"helpUri":"https://cwe.mitre.org/data/definitions/798.html"},{"id":"CWE-89","guid":"6d08fdad-37eb-c150-bbf0-d7d946863407","name":"Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)","shortDescription":{"text":"Improper Neutralization of Special Elements used in an SQL Command (\u0027SQL Injection\u0027)"},"helpUri":"https://cwe.mitre.org/data/definitions/89.html"},{"id":"CWE-937","guid":"16f316ae-415c-b354-a59b-1f7905f756e9","name":"Using Components with Known Vulnerabilities","shortDescription":{"text":"Using Components with Known Vulnerabilities"},"helpUri":"https://cwe.mitre.org/data/definitions/937.html"},{"id":"CWE-94","guid":"75e7f50c-6c2f-dd52-bf40-bf6c52b861fd","name":"Improper Control of Generation of Code (\u0027Code Injection\u0027)","shortDescription":{"text":"Improper Control of Generation of Code (\u0027Code Injection\u0027)"},"helpUri":"https://cwe.mitre.org/data/definitions/94.html"}]},{"name":"OWASP Top 10","guid":"7d1f0c2e-4b6a-4e39-9a51-0b2e8c3d5f61","version":"2025","organization":"OWASP Foundation","informationUri":"https://top10.owasp.org/2025/","isComprehensive":false,"shortDescription":{"text":"The OWASP Top 10:2025 web application security risks."},"taxa":[{"id":"A02:2025","guid":"668dee9e-41bc-6354-97d0-fdf8f40c50c1","name":"Security Misconfiguration","shortDescription":{"text":"Security Misconfiguration"},"helpUri":"https://top10.owasp.org/2025/A02_2025-Security_Misconfiguration/"},{"id":"A03:2025","guid":"168e227c-7735-2e57-bc6e-997affe644c5","name":"Software Supply Chain Failures","shortDescription":{"text":"Software Supply Chain Failures"},"helpUri":"https://top10.owasp.org/2025/A03_2025-Software_Supply_Chain_Failures/"},{"id":"A05:2025","guid":"87e86033-3231-8458-8e4a-5cb82743553a","name":"Injection","shortDescription":{"text":"Injection"},"helpUri":"https://top10.owasp.org/2025/A05_2025-Injection/"},{"id":"A07:2025","guid":"334ddd78-539d-d35c-83dd-253647eb7eaf","name":"Authentication Failures","shortDescription":{"text":"Authentication Failures"},"helpUri":"https://top10.owasp.org/2025/A07_2025-Authentication_Failures/"},{"id":"A08:2025","guid":"84b0c297-710e-9a5f-9335-936ecb260c36","name":"Software or Data Integrity Failures","shortDescription":{"text":"Software or Data Integrity Failures"},"helpUri":"https://top10.owasp.org/2025/A08_2025-Software_or_Data_Integrity_Failures/"}]},{"name":"OWASP Top 10 CI/CD Security Risks","guid":"3c9b2a6e-5d14-4f7b-8e02-6a1d9c4b7f35","organization":"OWASP Foundation","informationUri":"https://owasp.org/www-project-top-10-ci-cd-security-risks/","isComprehensive":false,"shortDescription":{"text":"The OWASP Top 10 CI/CD Security Risks."},"taxa":[{"id":"CICD-SEC-3","guid":"458c83a6-ebf7-cf55-8cc3-b4d949bbf271","name":"Dependency Chain Abuse","shortDescription":{"text":"Dependency Chain Abuse"},"helpUri":"https://owasp.github.io/www-project-top-10-ci-cd-security-risks/CICD-SEC-03-Dependency-Chain-Abuse"},{"id":"CICD-SEC-4","guid":"c859d8ea-8b24-a157-9406-94929c10397a","name":"Poisoned Pipeline Execution (PPE)","shortDescription":{"text":"Poisoned Pipeline Execution (PPE)"},"helpUri":"https://owasp.github.io/www-project-top-10-ci-cd-security-risks/CICD-SEC-04-Poisoned-Pipeline-Execution"},{"id":"CICD-SEC-8","guid":"b6b2dacf-a168-4957-876e-a8c73ee00eb0","name":"Ungoverned Usage of 3rd Party Services","shortDescription":{"text":"Ungoverned Usage of 3rd Party Services"},"helpUri":"https://owasp.github.io/www-project-top-10-ci-cd-security-risks/CICD-SEC-08-Ungoverned-Usage-of-3rd-Party-Services"},{"id":"CICD-SEC-9","guid":"b3d36727-0395-5b51-94c4-5e173d62eab3","name":"Improper Artifact Integrity Validation","shortDescription":{"text":"Improper Artifact Integrity Validation"},"helpUri":"https://owasp.github.io/www-project-top-10-ci-cd-security-risks/CICD-SEC-09-Improper-Artifact-Integrity-Validation"}]}],"properties":{"codehealthPublication":{"public":true,"notice":"This is the PUBLIC form of this artifact. Findings are listed in full, but the details of SECURITY findings \u2014 which rule fired, in which file, on which line, and how to fix it \u2014 are deliberately withheld, and any secret-scanner results are excluded entirely. Where detail is absent here it was REMOVED FOR PUBLICATION; it is not missing from the analysis. The complete artifact is available from the repository owner.","securityFindingsRedacted":33,"secretScannerRunsExcluded":0}},"redactionTokens":["A security finding was recorded here. Its details are withheld on the public artifact \u2014 ask the repository owner for the full report."]}]}