{"$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":"D4","name":"Code Duplication","shortDescription":{"text":"Code Duplication"},"helpUri":"https://codehealth.canine.dev/dimensions/D4"},{"id":"D8","name":"Code Coverage","shortDescription":{"text":"Code Coverage"},"helpUri":"https://codehealth.canine.dev/dimensions/D8"},{"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"]}],"properties":{"cwe":["CWE-798","CWE-259"]}},{"id":"D15","name":"Churn \u00D7 Complexity Hotspots","shortDescription":{"text":"Churn \u00D7 Complexity Hotspots"},"helpUri":"https://codehealth.canine.dev/dimensions/D15"},{"id":"D16","name":"Bus Factor","shortDescription":{"text":"Bus Factor"},"helpUri":"https://codehealth.canine.dev/dimensions/D16"},{"id":"D19","name":"Documentation Quality","shortDescription":{"text":"Documentation Quality"},"helpUri":"https://codehealth.canine.dev/dimensions/D19"},{"id":"D21","name":"Naming Consistency","shortDescription":{"text":"Naming Consistency"},"helpUri":"https://codehealth.canine.dev/dimensions/D21"},{"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"]}],"properties":{"cwe":["CWE-798","CWE-259"]}},{"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"]}],"properties":{"cwe":["CWE-79","CWE-89","CWE-78","CWE-94","CWE-77"]}},{"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"]}],"properties":{"cwe":["CWE-1395","CWE-937"]}},{"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"]}],"properties":{"cwe":["CWE-1032","CWE-732","CWE-16"]}},{"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"}]}},"results":[{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitWhere (cyclomatic 87): LinqExpressionVisitors.visitWhere has cyclomatic complexity 87 (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/LinqExpressionVisitors.fs"},"region":{"startLine":485}}}],"partialFingerprints":{"codehealthFindingId/v1":"2a858b4449c77313151605ac23837ca8ab021fca8d5747be9fffd1a1a4e6af16"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitSelect (cyclomatic 48): LinqExpressionVisitors.visitSelect has cyclomatic complexity 48 (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/LinqExpressionVisitors.fs"},"region":{"startLine":1115}}}],"partialFingerprints":{"codehealthFindingId/v1":"802393090df9aa278db72f32686440c52999f744e5a6c319051b8ce48dee7b84"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitHaving (cyclomatic 34): LinqExpressionVisitors.visitHaving has cyclomatic complexity 34 (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/LinqExpressionVisitors.fs"},"region":{"startLine":803}}}],"partialFingerprints":{"codehealthFindingId/v1":"b0900eae1a21e17e76f48398bc31e0c37f0a83c544bebafcfc2bca81a123f6a0"}},{"ruleId":"D1","level":"warning","message":{"text":"SqlEmitterBase.EmitSelectInto (cyclomatic 19): SqlEmitterBase.EmitSelectInto has cyclomatic complexity 19 (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":196}}}],"partialFingerprints":{"codehealthFindingId/v1":"d008900dd5821076444827402d262a0543fc1d6e81b723e1d5f6b3b87e144a1a"}},{"ruleId":"D1","level":"warning","message":{"text":"LinqExpressionVisitors.visitJoinPredicate (cyclomatic 18): LinqExpressionVisitors.visitJoinPredicate 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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1036}}}],"partialFingerprints":{"codehealthFindingId/v1":"c106f27af05227611c0be1b7794d3227a81f61fdb21c9188a550cbe9369ce0e0"}},{"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":19}}}],"partialFingerprints":{"codehealthFindingId/v1":"194f59c06018e7ffd5aa666ef2069b43b91cbeb64b86f4d0c952aa84956bfdb5"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitWhere (cognitive 89): LinqExpressionVisitors.visitWhere has cognitive complexity 89 (threshold 15). Drivers by points: match/switch 41, if/else 36, boolean chains 12 (nesting depth added 41). 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/LinqExpressionVisitors.fs"},"region":{"startLine":485}}}],"partialFingerprints":{"codehealthFindingId/v1":"62af67555a9fa3a85e19d300935a415c3cb5787bbd2103e8692039f0e3c202f2"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitSelect (cognitive 53): LinqExpressionVisitors.visitSelect has cognitive complexity 53 (threshold 15). Drivers by points: match/switch 33, if/else 11, boolean chains 9 (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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/LinqExpressionVisitors.fs"},"region":{"startLine":1115}}}],"partialFingerprints":{"codehealthFindingId/v1":"8ce80b7f5f70509aee82fdbe4c98ccfd1ac77f04fb0c24373796d4d16fb3f587"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitHaving (cognitive 43): LinqExpressionVisitors.visitHaving has cognitive complexity 43 (threshold 15). Drivers by points: match/switch 22, if/else 20, boolean chains 1 (nesting depth added 22). 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/LinqExpressionVisitors.fs"},"region":{"startLine":803}}}],"partialFingerprints":{"codehealthFindingId/v1":"c9b518081324c95dcddaa08cbda4a81501cee198f7be1a32f5410a8ecbfe6762"}},{"ruleId":"D2","level":"warning","message":{"text":"QueryContext.PrepareInsertCommand (cognitive 27): QueryContext.PrepareInsertCommand has cognitive complexity 27 (threshold 15). Drivers by points: if/else 20, loops 4, match/switch 3 (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":266}}}],"partialFingerprints":{"codehealthFindingId/v1":"ec0bd9b3c0373a03dc5eb6d80d75b1507f368e1f72e27cf0ecfac4e949438a8b"}},{"ruleId":"D2","level":"warning","message":{"text":"SchemaTemplate.mkTable (cognitive 25): SchemaTemplate.mkTable has cognitive complexity 25 (threshold 15). Drivers by points: if/else 17, match/switch 5, boolean chains 2, loops 1 (nesting depth added 10). 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":31}}}],"partialFingerprints":{"codehealthFindingId/v1":"ffd3b0aaa5c7112417313060196fb8aaafea1fd288e5f4252bef1295f84d27d2"}},{"ruleId":"D2","level":"warning","message":{"text":"ColumnReadMethods.ConvertOracleProviderType (cognitive 21): ColumnReadMethods.ConvertOracleProviderType has cognitive complexity 21 (threshold 15). Drivers by points: if/else 21 (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":"SqlEmitterBase.EmitSelectInto (cognitive 18): SqlEmitterBase.EmitSelectInto has cognitive complexity 18 (threshold 15). Drivers by points: match/switch 10, if/else 7, loops 1 (nesting depth added 5). 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":196}}}],"partialFingerprints":{"codehealthFindingId/v1":"5ba7786b29bbe790d9c3614bf908dbaddf5ece409d27128b52268cef5800582b"}},{"ruleId":"D2","level":"warning","message":{"text":"NpgsqlSchemaProvider.getSchema (cognitive 16): NpgsqlSchemaProvider.getSchema has cognitive complexity 16 (threshold 15). Drivers by points: if/else 11, loops 3, match/switch 2 (nesting depth added 1). 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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs"},"region":{"startLine":7}}}],"partialFingerprints":{"codehealthFindingId/v1":"34945288a577f80722303459a1895408b1473ecb408761ebd7dd48a451c2d3b3"}},{"ruleId":"D2","level":"warning","message":{"text":"LinqExpressionVisitors.visitJoinPredicate (cognitive 16): LinqExpressionVisitors.visitJoinPredicate has cognitive complexity 16 (threshold 15). Drivers by points: match/switch 16 (nesting depth added 9). 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/LinqExpressionVisitors.fs"},"region":{"startLine":1036}}}],"partialFingerprints":{"codehealthFindingId/v1":"0e4469567224c6a86fc984fd4b6b605ebe1324849690ee892ea4feb6c62ab1ac"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (17 lines \u00D7 2): src/SqlHydra.Cli/SqlServer/SqlServerDataTypes.fs:54-70 | src/SqlHydra.Cli/MySql/MySqlDataTypes.fs:59-75 \u2014 the copies span different directories, so extracting a shared function means choosing where it lives: put it somewhere both 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 twice. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/SqlServer/SqlServerDataTypes.fs:54\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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SqlServer/SqlServerDataTypes.fs"},"region":{"startLine":54}}}],"partialFingerprints":{"codehealthFindingId/v1":"12272eed586169d24741e2db02e26bec9fa20f972d0d4bc61a549d81b82133b1"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (16 lines \u00D7 4): src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:108-123 | src/SqlHydra.Cli/Sqlite/SqliteSchemaProvider.fs:220-235 | src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs:149-164 | src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:113-128 \u2014 the copies span different directories, so extracting a shared function means choosing where it lives: put it somewhere all 4 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 4 times. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:108\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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs"},"region":{"startLine":108}}}],"partialFingerprints":{"codehealthFindingId/v1":"1ca1a18a8d2407fe1a549bebca9e914751fb30970eab110fbacaa5b7ad4d1c47"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (14 lines \u00D7 2): src/SqlHydra.Cli/MySql/MySqlDataTypes.fs:64-77 | src/SqlHydra.Cli/Npgsql/NpgsqlDataTypes.fs:85-98 \u2014 the copies span different directories, so extracting a shared function means choosing where it lives: put it somewhere both 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 twice. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/MySql/MySqlDataTypes.fs:64\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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlDataTypes.fs"},"region":{"startLine":64}}}],"partialFingerprints":{"codehealthFindingId/v1":"fc631b622d290ea75a34c901b998bab1ae9925f9827e16ca3d1708ac1da496fd"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (14 lines \u00D7 2): src/SqlHydra.Query/SqlEmitters.fs:127-140 | src/SqlHydra.Query/SqlEmitters.fs:186-199 \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/SqlEmitters.fs"},"region":{"startLine":127}}}],"partialFingerprints":{"codehealthFindingId/v1":"d526917e9ffc832eac3a843e054fe3aa90dc4d86c7924f08d15fae19e1185bf4"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (13 lines \u00D7 2): src/SampleApp/DapperExample.fs:42-54 | src/SampleApp/DonaldExample.fs:43-55 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SampleApp/DapperExample.fs:42\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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SampleApp/DapperExample.fs"},"region":{"startLine":42}}}],"partialFingerprints":{"codehealthFindingId/v1":"0df1a11795c5d03762baae8f91e2635020855a60c0b88e8c3ad9ab7e01b20b0e"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (13 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:583-595 | src/SqlHydra.Query/SelectBuilders.fs:682-694 \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:583\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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SelectBuilders.fs"},"region":{"startLine":583}}}],"partialFingerprints":{"codehealthFindingId/v1":"5667cafcae79bdd16236708ea32568e111645c0eae488a8634b68ffd6c78b59d"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (12 lines \u00D7 2): src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:54-65 | src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:60-71 \u2014 the copies span different directories, so extracting a shared function means choosing where it lives: put it somewhere both 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 twice. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:54\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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs"},"region":{"startLine":54}}}],"partialFingerprints":{"codehealthFindingId/v1":"5c8e3e7b3613595dda68eae98714eb7587dcf4c21e585b3a167e7973a2c458f4"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (12 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:346-357 | src/SqlHydra.Query/SelectBuilders.fs:377-388 \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:346\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":346}}}],"partialFingerprints":{"codehealthFindingId/v1":"2a64eb7c2f38bae95dec65709b11d7f491cad45337ab6ab9c54e65f811bff24d"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (11 lines \u00D7 2): src/SqlHydra.Cli/SchemaFilters.fs:21-31 | src/SqlHydra.Cli/SchemaFilters.fs:54-64 \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.Cli/SchemaFilters.fs"},"region":{"startLine":21}}}],"partialFingerprints":{"codehealthFindingId/v1":"84ad6802d3d4d299dee2779fc1920e1cae49f9c78585594ac45a13868ae6e094"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (11 lines \u00D7 2): src/SqlHydra.Cli/SqlServer/SqlServerSchemaProvider.fs:25-35 | src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:47-57 \u2014 the copies span different directories, so extracting a shared function means choosing where it lives: put it somewhere both 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 twice. 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/SqlServer/SqlServerSchemaProvider.fs"},"region":{"startLine":25}}}],"partialFingerprints":{"codehealthFindingId/v1":"6de5dfc51bb65c688b83bde46b8e458d3860afb8fb9e694fe841465bca4a25f2"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (11 lines \u00D7 2): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:56-66 | src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:104-114 \u2014 the copies span different directories, so extracting a shared function means choosing where it lives: put it somewhere both 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 twice. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:56\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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":56}}}],"partialFingerprints":{"codehealthFindingId/v1":"54a28608df03f1b29b768bde599027eb6a8ef89f7d48f06421c37f5572633eae"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (11 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:242-252 | src/SqlHydra.Query/SelectBuilders.fs:289-299 \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":242}}}],"partialFingerprints":{"codehealthFindingId/v1":"8cc9ce6fb15f9aca6271028f8af92be05c1a84dac0829a0f76b51002883d9924"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (9 lines \u00D7 4): src/SqlHydra.Query/LinqExpressionVisitors.fs:514-522 | src/SqlHydra.Query/LinqExpressionVisitors.fs:523-531 | src/SqlHydra.Query/LinqExpressionVisitors.fs:826-834 | src/SqlHydra.Query/LinqExpressionVisitors.fs:835-843 \u2014 all 4 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":514}}}],"partialFingerprints":{"codehealthFindingId/v1":"ff03580a9436830bf5796489187e2ae663c95475dd507d2eb03dda75865ed0f9"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (9 lines \u00D7 2): src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:225-233 | src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:282-290 \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.Cli/Npgsql/NpgsqlSchemaProvider.fs:225\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.Cli/Npgsql/NpgsqlSchemaProvider.fs"},"region":{"startLine":225}}}],"partialFingerprints":{"codehealthFindingId/v1":"2199883fa6482fb6edb12a81e785219b3ff7128ddc3f0a4442e6286edca71b6d"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (9 lines \u00D7 2): src/SqlHydra.Query/NpgsqlExtensions.fs:68-76 | src/SqlHydra.Query/SqliteExtensions.fs:62-70 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/NpgsqlExtensions.fs"},"region":{"startLine":68}}}],"partialFingerprints":{"codehealthFindingId/v1":"6b0ec559f37427858b84a31b719ce6a642f19b4d1be61fef493980d087eac2f9"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (9 lines \u00D7 2): src/SqlHydra.Query/NpgsqlExtensions.fs:80-88 | src/SqlHydra.Query/SqliteExtensions.fs:74-82 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/NpgsqlExtensions.fs"},"region":{"startLine":80}}}],"partialFingerprints":{"codehealthFindingId/v1":"3ac2729ba948a54e19bdf3fc3055b80c96d23102c315c0a52b0bd91357b328c5"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:42-49 | src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs:90-97 \u2014 the copies span different directories, so extracting a shared function means choosing where it lives: put it somewhere both 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 twice. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Cli/MySql/MySqlSchemaProvider.fs:42\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.Cli/MySql/MySqlSchemaProvider.fs"},"region":{"startLine":42}}}],"partialFingerprints":{"codehealthFindingId/v1":"8e009c1f9dcd67ca5a6b251a1a14021b9876ae843dd93eebe2a45082e154e07a"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:675-682 | src/SqlHydra.Query/LinqExpressionVisitors.fs:907-914 \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":675}}}],"partialFingerprints":{"codehealthFindingId/v1":"6eb6b767ef6e3b6f0f0d29fe82be41a9519038f86ccea8f7afdba577e8ca7c85"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:733-740 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1070-1078 \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/LinqExpressionVisitors.fs"},"region":{"startLine":733}}}],"partialFingerprints":{"codehealthFindingId/v1":"9dc542490badfb207b893d9bf908695fa35f6c73e7d8b802a9a653d20ff3d006"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:908-915 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1058-1067 \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":908}}}],"partialFingerprints":{"codehealthFindingId/v1":"ab9c413a804632b9620a58fd1bc360b8d108507884c61370c0bd6cd14380c53f"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (8 lines \u00D7 2): src/SqlHydra.Query/UpdateBuilders.fs:73-80 | src/SqlHydra.Query/DeleteBuilders.fs:32-39 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/UpdateBuilders.fs"},"region":{"startLine":73}}}],"partialFingerprints":{"codehealthFindingId/v1":"f571ee3ee6d983a206fc3c763a8cdfc8cf7616ab450383225bd0fe5b3d0e465f"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (7 lines \u00D7 4): src/SqlHydra.Query/SqlEmitters.fs:83-89 | src/SqlHydra.Query/SqlEmitters.fs:143-149 | src/SqlHydra.Query/SqlEmitters.fs:202-208 | src/SqlHydra.Query/SqlEmitters.fs:254-260 \u2014 all 4 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/SqlEmitters.fs"},"region":{"startLine":83}}}],"partialFingerprints":{"codehealthFindingId/v1":"42cc7f9a9065b7075beb03fc84b4928d6f0b743ef76fe99447083a1165f6f209"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (7 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:805-811 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1039-1045 \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/LinqExpressionVisitors.fs"},"region":{"startLine":805}}}],"partialFingerprints":{"codehealthFindingId/v1":"fc6f690e3ef3fea7b2bd7109cfe30594ee803c0cba7a0fe6e5542f46c9b341c6"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (7 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:169-175 | src/SqlHydra.Query/SelectBuilders.fs:191-197 \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":169}}}],"partialFingerprints":{"codehealthFindingId/v1":"e1fbca092ceab2bc394dcfa8eece2f1ce43cfb0c465984c1db89b7a1eeaa8921"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (7 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:549-555 | src/SqlHydra.Query/SelectBuilders.fs:570-576 \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:549\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":549}}}],"partialFingerprints":{"codehealthFindingId/v1":"b982615faabf61455006028cc349b9c1ce6d31bbc0382f5c75354db636ba46a3"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (7 lines \u00D7 2): src/SqlHydra.Query/SelectBuilders.fs:644-650 | src/SqlHydra.Query/SelectBuilders.fs:667-673 \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:644\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":644}}}],"partialFingerprints":{"codehealthFindingId/v1":"ea28570265fd98a7ebeafa2355f0b9d14adaef3cc378a3f365b95c06d642dc5e"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (7 lines \u00D7 2): src/SqlHydra.Query/UpdateBuilders.fs:119-125 | src/SqlHydra.Query/DeleteBuilders.fs:74-80 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Query/UpdateBuilders.fs:119\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/UpdateBuilders.fs"},"region":{"startLine":119}}}],"partialFingerprints":{"codehealthFindingId/v1":"6ed59d36bd651bbadfc73b4aa235e81a822d9cace02ea71d3275df8b4c0849f7"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 3): src/SqlHydra.Query/LinqExpressionVisitors.fs:486-492 | src/SqlHydra.Query/LinqExpressionVisitors.fs:804-809 | src/SqlHydra.Query/LinqExpressionVisitors.fs:1038-1043 \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":486}}}],"partialFingerprints":{"codehealthFindingId/v1":"12d539a007a55450c42ee484f40b0673ff77b67c5c1cf1837859dce54775b6ba"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/SqlEmitterBase.fs:102-107 | src/SqlHydra.Query/SqlEmitterBase.fs:171-176 \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/SqlEmitterBase.fs"},"region":{"startLine":102}}}],"partialFingerprints":{"codehealthFindingId/v1":"5643a3ff1daf5f92c1fc01a662c802cdd2770db5cf6bdb5ee754b9672f80e84b"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:588-593 | src/SqlHydra.Query/LinqExpressionVisitors.fs:597-602 \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":588}}}],"partialFingerprints":{"codehealthFindingId/v1":"e7b6cc71e6e4d16f28548732c9f6a952086ad89e2e308886722823a0aed6515c"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:607-612 | src/SqlHydra.Query/LinqExpressionVisitors.fs:616-621 \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":607}}}],"partialFingerprints":{"codehealthFindingId/v1":"06e537126e6502caffc08647d05fb249eaa16378910c4dc1903af7af12d16f43"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/InsertBuilders.fs:19-24 | src/SqlHydra.Query/UpdateBuilders.fs:25-30 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once. Read the line range as the matched WINDOW rather than a finished unit: at \u0060src/SqlHydra.Query/InsertBuilders.fs:19\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/InsertBuilders.fs"},"region":{"startLine":19}}}],"partialFingerprints":{"codehealthFindingId/v1":"91e052ad1259100986e1ac0cc707a6e8d7d89e9e4bd0cc58f5e0f9c9723d3047"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/SqlServerExtensions.fs:93-98 | src/SqlHydra.Query/SqlServerExtensions.fs:118-123 \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/SqlServerExtensions.fs:93\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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlServerExtensions.fs"},"region":{"startLine":93}}}],"partialFingerprints":{"codehealthFindingId/v1":"545a22910caa4f4a1684d6ee344a0a91030649b3886f607f3e8b549cd17ae4ea"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/NpgsqlExtensions.fs:39-44 | src/SqlHydra.Query/SqliteExtensions.fs:36-41 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/NpgsqlExtensions.fs"},"region":{"startLine":39}}}],"partialFingerprints":{"codehealthFindingId/v1":"ba554aff7d9290590f0aba1c4c3657c1313d8a3e540861eb8eff0a4507882b0a"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (6 lines \u00D7 2): src/SqlHydra.Query/OracleExtensions.fs:42-47 | src/SqlHydra.Query/MySqlExtensions.fs:50-55 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/OracleExtensions.fs"},"region":{"startLine":42}}}],"partialFingerprints":{"codehealthFindingId/v1":"d6c072a0b11bf31f6d2917d956f2222e37b640a0d36478e728f0418265c3c6f7"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (5 lines \u00D7 3): src/SqlHydra.Query/SqlServerExtensions.fs:11-15 | src/SqlHydra.Query/OracleExtensions.fs:10-14 | src/SqlHydra.Query/MySqlExtensions.fs:12-16 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlServerExtensions.fs"},"region":{"startLine":11}}}],"partialFingerprints":{"codehealthFindingId/v1":"051483cdf9549c6be72e630190a306d86010658aea239ffee92d2e75418a82e5"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (5 lines \u00D7 2): src/SqlHydra.Query/LinqExpressionVisitors.fs:273-277 | src/SqlHydra.Query/LinqExpressionVisitors.fs:378-382 \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":273}}}],"partialFingerprints":{"codehealthFindingId/v1":"66f43bf9fc30d4e8ceb1eb3f1f89577b7d75987036fd6195d93c67f4ada5e668"}},{"ruleId":"D4","level":"warning","message":{"text":"Duplicated block (5 lines \u00D7 2): src/SqlHydra.Query/NpgsqlExtensions.fs:11-15 | src/SqlHydra.Query/SqliteExtensions.fs:9-13 \u2014 the copies sit in sibling files of one directory: extract the block into a single shared function in that directory and call it from each site, so a change lands once."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/NpgsqlExtensions.fs"},"region":{"startLine":11}}}],"partialFingerprints":{"codehealthFindingId/v1":"3de25c8055bc70e090b6b0c38988d884fbf164ff2dfefc503227815745f74e99"}},{"ruleId":"D8","level":"warning","message":{"text":"Coverage not measured \u2014 no coverage collector is wired up: Coverage NOT MEASURED: the test suite built and its tests PASSED, but the run produced no coverage data \u2014 \u0060--collect:\u0022XPlat Code Coverage\u0022\u0060 found no data collector, which is what a test project with no \u0060coverlet.collector\u0060 PackageReference does. Nothing is wrong with the suite or the build; there is simply no coverage instrumentation wired up. Add a \u0060coverlet.collector\u0060 PackageReference to the test project(s) (or commit the Cobertura/OpenCover/lcov report your CI produces) and real coverage will be measured. It is excluded from the score rather than counted as a near-zero defect."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"62e63e619c28f057e129f2997c965d32a457366a9ce18ca019ffb6bdfba85c99"}},{"ruleId":"D13","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":"d2070b8ff07efab911e329c4648f1d07e7f385344edbe449b060f18deb0396b3"},"taxa":[{"id":"CWE-259","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}}]},{"ruleId":"D13","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":"766630b4257a33604ccd44c703137804c6d700fd3094021d5bbde6a5059bf634"},"taxa":[{"id":"CWE-259","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}}]},{"ruleId":"D13","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":"4d1489d4f28549171fc76da88ecfaf916cbb5c3d4d7fa5bf2c5bb63061a60b65"},"taxa":[{"id":"CWE-259","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}}]},{"ruleId":"D13","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":"ecbf7cbc4bae1b0014b71b049b54710e1761a8509e02439e8a570724e72f3169"},"taxa":[{"id":"CWE-259","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}}]},{"ruleId":"D13","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":"eb4482b21e3c27a82950e7bd47ed589ddaa917b1810a29d00eb17362bf6288a6"},"taxa":[{"id":"CWE-259","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}},{"id":"CWE-798","toolComponent":{"name":"CWE","guid":"c3a2b1d0-7f3e-4b2a-9c1d-5e6f7a8b9c0d"}}]},{"ruleId":"D15","level":"warning","message":{"text":"Hotspot: src/SqlHydra.Query/SqlEmitterBase.fs: src/SqlHydra.Query/SqlEmitterBase.fs changed 2 times in last 90 days, max complexity 23. 1 of those changes was a fix/bug commit, and the other 1 changed it for other reasons \u2014 this file is under both repair and feature pressure. Before the next change lands here, cover the area it touches with tests, 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."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"src/SqlHydra.Query/SqlEmitterBase.fs"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"b94651638428964ef5a6d8ce531216a7dacc34d22c280052e8d55220f2c17653"}},{"ruleId":"D16","level":"note","message":{"text":"Off-boarding risk: anonymized user #1: If anonymized user #1 becomes unavailable, 18 significant file(s) lose their only recent owner: src/SqlHydra.Query/LinqExpressionVisitors.fs, src/SqlHydra.Cli/SchemaGenerator.fs, src/SqlHydra.Cli/Npgsql/NpgsqlSchemaProvider.fs, src/SqlHydra.Query/Hydration.fs, src/SqlHydra.Query/SqlEmitters.fs, src/SqlHydra.Cli/SchemaTemplate.fs, src/SqlHydra.Query/SqlServerExtensions.fs, src/SqlHydra.Cli/Oracle/OracleSchemaProvider.fs (\u002B10 more). Pair on, review, or document these before any departure."},"locations":[],"partialFingerprints":{"codehealthFindingId/v1":"765db9d83855a9ebcd79ee71037138b45091dea429826a72459363f016301d48"}},{"ruleId":"D19","level":"note","message":{"text":"The quick start assumes a single database type (SQL Server) and omits TOML configuration for multiple databases, which is covered by the architecture docs.: Add a brief note under Step 2 that SqlHydra.Cli supports multiple TOML databases out of the box so users can select any supported backend without changing the CLI command."},"locations":[{"physicalLocation":{"artifactLocation":{"uri":"README.md"},"region":{"startLine":1}}}],"partialFingerprints":{"codehealthFindingId/v1":"225f17d710f0ae7a0b78088896b6783aa85dd10dcdc29571b9903b39bab217fd"}},{"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"}},{"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"}},{"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"}},{"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"}},{"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"}},{"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":"76fcbc4b336aee9ba2226e1cccce9f9ff607a7c674dce255b4aec71c1a56ca49"}},{"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":"a032a72549b25fa4b110e49c0f8600b47f75a4b99d48bdca2b066d4b34e0c034"}},{"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"}},{"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"}},{"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"}},{"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"}},{"ruleId":"D30","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":"626d0f9bc2a4dc54e69bf1646c0e82ca21e35de834996dce34f8cfc90e4588b8"}},{"ruleId":"D30","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":"655d03e4bab03415a7a1cd63e9bfa256517be2ba114e00dbbed29519dd5b5252"}},{"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":"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":"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":"2d8afc51f741dd8f12fa0daed99cd4d0b51495e5537af4a112810adff59406f0"}},{"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":"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":"456a48ca408a6bd62330da4e2c41c68b77f415e86ccafe448479ffcebb031cb4"}}],"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-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-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":"Command Injection","shortDescription":{"text":"Command Injection"},"helpUri":"https://cwe.mitre.org/data/definitions/77.html"},{"id":"CWE-78","guid":"2e31ceaf-c7ae-2e5e-9661-cfb1362789cf","name":"OS Command Injection","shortDescription":{"text":"OS Command Injection"},"helpUri":"https://cwe.mitre.org/data/definitions/78.html"},{"id":"CWE-79","guid":"fd45580b-e8c4-fc5e-8c2f-aa8fab0b4dbf","name":"Cross-site Scripting (XSS)","shortDescription":{"text":"Cross-site Scripting (XSS)"},"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":"SQL Injection","shortDescription":{"text":"SQL Injection"},"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":"Code Injection","shortDescription":{"text":"Code Injection"},"helpUri":"https://cwe.mitre.org/data/definitions/94.html"}]}],"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":26,"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."]}]}