dvryaboy/dblect

View on GitHub

Test your data for meaning

Stars: 21
Forks: 2
Open beginner issues: 1
Indexed issues: 67
Avg merge: 1d 6h
Merged PRs (30d): 26

Dominant language: Python
License: Apache-2.0
Last GitHub push: Sep 20, 2026
Latest indexed: Sep 20, 2026
Contributing guide: No contributing guide
Code of conduct: No code of conduct
Beginner labels: No beginner labels indexed

Beginner friendly Everything

Open All

66 open issues indexed

calibration: LEFT JOIN to a keyed lookup on a nullable code column, should it grade quieter? Open

question

Difficulty 5/5 Over a week Newbie friendliness 35/100

dvryaboy/dblect#287 · Opened Sep 21, 2026
runtime guards: compile declared facts and Field constraints to executable checks Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 30/100

dvryaboy/dblect#286 · Opened Sep 21, 2026
uniqueness: a declared input key does not reach a covering window two models downstream (tuva-core npi_normalize) Open

bug

Difficulty 4/5 3-5 days Newbie friendliness 52/100

dvryaboy/dblect#285 · Opened Sep 21, 2026
contracts: a totality facet on references, read by nullability through LEFT JOIN Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

dvryaboy/dblect#284 · Opened Sep 21, 2026
contracts: composite references / multi-column ForeignKey edges Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 38/100

dvryaboy/dblect#283 · Opened Sep 21, 2026
contracts: tuple determinants on determines, with an explicit NULL rule Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

dvryaboy/dblect#282 · Opened Sep 21, 2026
contracts: a not_null fact with a where scope (conditional nullability declaration) Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 45/100

dvryaboy/dblect#281 · Opened Sep 21, 2026
enhancement: literal pairs across UNION arms define a functional dependency the engine can mint Open

Difficulty 4/5 3-5 days Newbie friendliness 57/100

dvryaboy/dblect#273 · Opened Sep 16, 2026
bug: a Jinja-bearing column in unique_combination_of_columns kwargs grounds a key with a phantom column Open

Difficulty 3/5 1-2 days Newbie friendliness 82/100

dvryaboy/dblect#271 · Opened Sep 16, 2026
enhancement: a projected row_number is a structural conditional key that a downstream rn = 1 filter activates Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

dvryaboy/dblect#269 · 1 comment · Opened Sep 16, 2026
fix(contracts): accept string literals in contract comparisons Open

Difficulty 4/5 3-5 days Newbie friendliness 64/100

dvryaboy/dblect#229 · Opened Aug 20, 2026
feat(report): standing trust-versus-proof caveat in text, JSON, and SARIF Open

Difficulty 4/5 3-5 days Newbie friendliness 58/100

dvryaboy/dblect#228 · Opened Aug 20, 2026
feat(check): surface the nullability not-established finding Open

Difficulty 4/5 3-5 days Newbie friendliness 55/100

dvryaboy/dblect#227 · Opened Aug 20, 2026
feat(check): dead-predicate / enum-coverage check over accepted-value sets Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 52/100

dvryaboy/dblect#205 · Opened Jul 9, 2026
feat(lineage): value-interval property + range/non-negativity violation check Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 48/100

dvryaboy/dblect#204 · Opened Jul 9, 2026
feat(types): non-additive (stock/flow) facet — flag a cross-dimension SUM of a level Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 52/100

dvryaboy/dblect#203 · Opened Jul 9, 2026
feat(check): emit declared-vs-inferred contradictions for keys and functional dependencies Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 55/100

dvryaboy/dblect#202 · Opened Jul 9, 2026
feat(contracts): consume ResolvedPredicate — conservation, cardinality, referential-drop checks Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 32/100

dvryaboy/dblect#201 · 1 comment · Opened Jul 9, 2026
where_on_outer_joined_nullable: false positive on NULL-preserving predicates (COALESCE(pred, TRUE), OR x IS NULL, IS NOT DISTINCT FROM) Open

Difficulty 4/5 3-5 days Newbie friendliness 52/100

dvryaboy/dblect#196 · Opened Jun 30, 2026
parse: tolerate valid-BigQuery shapes that currently skip a model (trailing-comma no-FROM SELECT, correlated WITH OFFSET) Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

dvryaboy/dblect#192 · Opened Jun 29, 2026
check: unresolved-columns / facet-collapse detector for contract columns Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 45/100

dvryaboy/dblect#157 · Opened Jun 23, 2026
manifest: tag execute-time warehouse values as COMPUTED origin (split from #86) Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

dvryaboy/dblect#156 · Opened Jun 23, 2026
check: per-world finding diff so --base-* reports introduced findings per incremental world Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 45/100

dvryaboy/dblect#153 · Opened Jun 21, 2026
check: --base-ref to recompile the base revision both ways for the diff Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

dvryaboy/dblect#152 · Opened Jun 21, 2026
check: enumerate full-refresh and steady-state worlds in the CLI Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 65/100

dvryaboy/dblect#151 · Opened Jun 21, 2026
check: distinguish can't-prove aggregation findings (lineage gap / skipped Python model) from real conflicts Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

dvryaboy/dblect#138 · 1 comment · Opened Jun 20, 2026
contracts: let a @contract method assert multiple facts (return a tuple) Open

enhancement

Difficulty 3/5 1-2 days Newbie friendliness 64/100

dvryaboy/dblect#136 · Opened Jun 19, 2026
types: propagate standalone closed-category (NominalEnum) columns so categorical meaning shifts are caught Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

dvryaboy/dblect#135 · Opened Jun 19, 2026
Domain-type classifier: accept deferred scalar types (uuid, interval, semi-structured, binary, geography) Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 32/100

dvryaboy/dblect#131 · Opened Jun 19, 2026
Classify anonymous vendor aggregates by name (the type-keyed coverage gap) Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 55/100

dvryaboy/dblect#119 · Opened Jun 19, 2026
Lenient/strict mode: escalate tag-coherence widening to eager findings (incl. tag-blind min/max) Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

dvryaboy/dblect#116 · 2 comments · Opened Jun 19, 2026
analyze() parses each model's SQL twice (run_check + run_audit) Open

Difficulty 4/5 3-5 days Newbie friendliness 45/100

dvryaboy/dblect#112 · Opened Jun 19, 2026
Incremental worlds: mixed-state and target-dispatch refinements Open

Difficulty 5/5 Over a week Newbie friendliness 35/100

dvryaboy/dblect#108 · Opened Jun 19, 2026
Consider unifying Finding and CheckFinding representations Open

Difficulty 5/5 Over a week Newbie friendliness 25/100

dvryaboy/dblect#107 · Opened Jun 18, 2026
Lift dbt cap and supported_languages tolerant read once dbt-artifacts-parser models dbt 1.11.8+ Open

Difficulty 3/5 1-2 days Newbie friendliness 45/100

dvryaboy/dblect#106 · Opened Jun 17, 2026
flags: control-flow world evaluation (both compiled SQL forms per branch flag) Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 25/100

dvryaboy/dblect#100 · Opened Jun 15, 2026
flags: cone-based per-contract world scoping before enumeration Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

dvryaboy/dblect#99 · 2 comments · Opened Jun 15, 2026
flags: var-inference engine and `dblect scaffold flags` scaffolding Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 35/100

dvryaboy/dblect#98 · 1 comment · Opened Jun 15, 2026
lineage: model wildcard-table and computed-relation references as a typed lineage boundary Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 42/100

dvryaboy/dblect#87 · Opened Jun 15, 2026
domain-type: rebind companion bindings through projections (multi-hop aggregation discharge) Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

dvryaboy/dblect#76 · Opened Jun 11, 2026
Empirical soundness PBT: extend to multi-model chains, CTE-carried filters, and composite keys (#62 follow-up) Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 45/100

dvryaboy/dblect#64 · Opened Jun 6, 2026
Conditional facts: support disjunctive test predicates via DNF Open

Difficulty 4/5 3-5 days Newbie friendliness 48/100

dvryaboy/dblect#61 · Opened Jun 6, 2026
lineage(facts): additional fact sources (cross-package, warehouse metadata) Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 20/100

dvryaboy/dblect#51 · Opened Jun 2, 2026
docs(facts): sync companion design docs to Property[K, S] Open

documentation

Difficulty 3/5 1-2 days Newbie friendliness 55/100

dvryaboy/dblect#50 · Opened Jun 2, 2026
lineage(facts): unenforced-constraint finding + annotation-trace helper Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 45/100

dvryaboy/dblect#48 · Opened Jun 2, 2026
lineage(facts): typed/untyped seam erasure diagnostic Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

dvryaboy/dblect#47 · Opened Jun 2, 2026
lineage(facts): collect-and-continue recovery for fact contradictions Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

dvryaboy/dblect#46 · Opened Jun 2, 2026
lineage(facts): cross-property DepContext scope-binding Open

enhancement

Difficulty 5/5 Over a week Newbie friendliness 30/100

dvryaboy/dblect#45 · 1 comment · Opened Jun 2, 2026
lineage(facts): activate conditional facts (where-filtered tests) Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 48/100

dvryaboy/dblect#43 · Opened Jun 2, 2026
lineage(facts): opaque opt-out reader (OpaqueReader) Open

enhancement

Difficulty 4/5 3-5 days Newbie friendliness 55/100

dvryaboy/dblect#42 · Opened Jun 2, 2026

dvryaboy/dblect

Get new issues in your inbox