EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Declarative Causal Inference and Counterfactual Reasoning via SQL-Dialect Operators

Ronnit Peter, Suprio Ray, Moulay A. Akhloufi

Big Data and Cognitive Computing · 17.08.2026 · 10 (8) · 275

DOI: 10.3390/bdcc10080275 ↗

Kurz gefasst

Fachartikel in der Zeitschrift Big Data and Cognitive Computing, online erschienen am 17.08.2026. Verfasst von Ronnit Peter und 2 weiteren Autor:innen. Die Arbeit nennt 71 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0). Gefördert von: New Brunswick Innovation Foundation.

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

Relational databases power high-stakes decisions in lending, healthcare, and justice, yet SQL lacks native constructs for causal and counterfactual reasoning. Prior SQL-based causal systems address parts of this gap but do not unify treatment-effect estimation with counterfactual generation in a single, composable SQL surface. We present a system that extends the SQL dialect with two declarative operators: EXPLAIN_CAUSALLY_WHY (ψ) for estimating average and conditional treatment effects via meta-learners, and EXPLAIN_COUNTERFACTUAL (φ) for generating diverse, constraint-respecting alternatives via a hybrid KD-tree/LSH pipeline. Both operators consume standard SQL relations (joins, filters, projections) and return table-valued results with optional diagnostics, confidence intervals, and feasibility metrics. We formalize the operators in relational algebra, and describe our prototype system called PsiQL. On four evaluation datasets, PsiQL recovers a protective TWINS treatment effect, returns a non-significant COMPAS point ATE with imbalance diagnostics, flags HMDA covariate imbalance via built-in SMD checks, and generates constraint-respecting counterfactuals; a synthetic Census run serves as a balanced pipeline proof-of-concept alongside a real ACS diagnostic under severe imbalance.

Förderung

  • New Brunswick Innovation Foundation

Zitieren

APA

Peter, R., Ray, S., & Akhloufi, M. A. (2026). Declarative Causal Inference and Counterfactual Reasoning via SQL-Dialect Operators. Big Data and Cognitive Computing, 10(8), 275. https://doi.org/10.3390/bdcc10080275

Vancouver

Peter R, Ray S, Akhloufi MA. Declarative Causal Inference and Counterfactual Reasoning via SQL-Dialect Operators. Big Data and Cognitive Computing. 2026;10(8):275. doi:10.3390/bdcc10080275

BibTeX
@article{Peter2026,
  author = {Peter, Ronnit and Ray, Suprio and Akhloufi, Moulay A.},
  title = {Declarative Causal Inference and Counterfactual Reasoning via SQL-Dialect Operators},
  journal = {Big Data and Cognitive Computing},
  year = {2026},
  volume = {10},
  number = {8},
  pages = {275},
  doi = {10.3390/bdcc10080275}
}
Kostenlos starten →