{"schema_version":"papers/paper-detail-v1","title":"AV-SQL: Decomposing Complex Text-to-SQL Queries with Agentic Views","surface":"papers","opportunity_kernel":{"paper_id":"ccc5ae39-34f0-4745-9885-7865f67f29f6","title":"AV-SQL: Decomposing Complex Text-to-SQL Queries with Agentic Views","authors":["Minh Tam Pham","Trinh Pham","Tong Chen","Hongzhi Yin","Quoc Viet Hung Nguyen","Thanh Tam Nguyen"],"arxiv_id":"2604.07041v1","doi":null,"published_at":"2026-04-08T12:56:13.000Z","score_object":{"overall":{"value":8,"scale":"0-10","confidence":0.85,"confidence_reason":"Backfilled from persisted papers.viability_score.","model_version":"phase0-backfill-v1","pipeline_version":"phase0-kernel-v1","computed_at":"2026-04-09T16:03:25.119Z","fresh_until":"2026-05-09T16:03:25.119Z","is_stale":true,"source_count":1,"missingness":[]},"technical":{"value":1.4,"scale":"0-10","confidence":0.55,"confidence_reason":"Backfilled from paper_extraction_scorecards.reconstruction_score.","model_version":"phase0-backfill-v1","pipeline_version":"phase0-kernel-v1","computed_at":"2026-04-09T20:33:16.236Z","fresh_until":"2026-04-23T20:33:16.236Z","is_stale":true,"source_count":1,"missingness":["reproducibility_results.reproducibility_score","deployability_scores.score"]},"commercial":{"value":5,"scale":"0-10","confidence":0.75,"confidence_reason":"Backfilled from persisted commercial_flags and repo availability.","model_version":"phase0-backfill-v1","pipeline_version":"phase0-kernel-v1","computed_at":"2026-04-09T16:03:25.119Z","fresh_until":"2026-05-09T16:03:25.119Z","is_stale":true,"source_count":2,"missingness":[]},"market":{"value":5.9,"scale":"0-10","confidence":0.8,"confidence_reason":"Backfilled from distribution_readiness_scores.score.","model_version":"phase0-backfill-v1","pipeline_version":"phase0-kernel-v1","computed_at":"2026-04-10T00:13:46.257Z","fresh_until":"2026-04-24T00:13:46.257Z","is_stale":true,"source_count":1,"missingness":[]},"team":{"value":6.5,"scale":"0-10","confidence":0.42,"confidence_reason":"Heuristic fallback from paper author count and extracted affiliations.","model_version":"phase0-backfill-v1","pipeline_version":"phase0-kernel-v1","computed_at":"2026-04-09T16:03:25.119Z","fresh_until":"2026-04-23T16:03:25.119Z","is_stale":true,"source_count":2,"missingness":[]},"methodology":{"value":4.7,"scale":"0-10","confidence":0.82,"confidence_reason":"Backfilled from paper_extraction_scorecards.total_score.","model_version":"phase0-backfill-v1","pipeline_version":"phase0-kernel-v1","computed_at":"2026-04-09T16:03:41.001Z","fresh_until":"2026-05-09T16:03:41.001Z","is_stale":true,"source_count":2,"missingness":[]}},"evidence_receipt":{"freshness":"stale","proof_status":"partial","repo_status":"active","references_count":59,"source_count":4,"coverage":1,"missingness":[],"unresolved_unknowns":[],"last_verification_at":"2026-04-09T20:33:16.236Z"},"lineage_hash":"40176492ac79104249da3bfddee6ef7e234e8cd9fd19d1601105791c2555d8c8"},"distribution":null,"replication_evidence":[],"author_dna":[]}