Skip to content

About

No description, website, or topics provided.

Resources

Stars

1 star

Watchers

0 watching

Forks

Latest commit

 

History

10 Commits

Folders and files

NameName
Last commit message
Last commit date
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQL-Frontier-Eval: Benchmarking Frontier AI on Complex Analytical SQL

Evaluating semantic correctness, mathematical KPI integrity, and plan efficiency on modern analytical engines.
Built for the micro1 Eval Hackathon on HackerRank Engage.

CI Unit Tests Golden Baseline Live GitHub Pages Data Volume: 108M+ Zero-LLM CI Engine: DuckDB 2.0 Python: 3.11+ Hackathon: micro1 Gemini 3.8 Flash Claude Opus 4.6 GPT-OSS 120B License: MIT


📌 Motivation: Why Analytical SQL Evals Matter

Existing text-to-SQL benchmarks (e.g. Spider, BIRD) primarily test simple relational lookups and basic textbook joins. However, in enterprise analytics (Snowflake, BigQuery, Databricks, DuckDB), data engineers face subtle and catastrophic failure modes from frontier LLMs:

  1. Silent Metric Corruption (The Chasm Trap): When calculating aggregates across multiple 1-to-many child tables (e.g. Orders joined to both Discounts and Shipments), LLMs generate multi-table joins before GROUP BY. This cross-multiplies records and silently inflates financial KPIs (e.g. 4x gross sales) without triggering any SQL syntax errors.
  2. Computational Anti-Patterns: Frontier models frequently substitute window functions with quadratic triangular self-joins (ON a.ts >= b.ts - 30), triggering Cartesian row explosions that cause memory spills and crash analytical warehouse clusters.
  3. Subtle Logical Pitfalls: Models routinely fail three-valued SQL logic (NOT IN on subqueries with NULLs), miss boundary conditions on temporal SCD Type 2 joins, or misconfigure window frame default bounds.

SQL-Frontier-Eval provides a reproducible, deterministic evaluation suite to expose where frontier models break down and guide the generation of optimal analytical queries.


🏆 Headline Benchmark Results

Evaluated across the 8-category failure taxonomy using DuckDB 2.0:

Model / Evaluated Target Pass Rate Tasks Passed Avg Generation Latency Engine Exec Latency Primary Failure Modes Run Artifact Link
Claude Opus 4.6 (Thinking) 100.0% 8 / 8 6.9s 4.6 ms None (Zero failures across all 8 tasks) eval_run_agy_claude-opus-4-6-thinking_1794196279.json
Gemini 3.8 Flash (Low) 100.0% 8 / 8 4.6s 5.4 ms None (Zero failures across all 8 tasks, Fastest) eval_run_agy_gemini-3.8-flash-low_1794195725.json
Gemini 3.8 Flash (Medium) 100.0% 8 / 8 27.6s 4.5 ms None (Zero failures across all 8 tasks) eval_run_gemini-3.8-flash-medium_1794186799.json
Claude Sonnet 4.6 (Thinking) 87.5% 7 / 8 6.3s 4.8 ms Strict Funnel Precedence (CROSS_PRODUCT scalar join) eval_run_agy_claude-sonnet-4-6_1794196223.json
GPT-OSS 120B (Medium) 87.5% 7 / 8 6.5s 5.5 ms Strict Funnel Precedence (CROSS_PRODUCT scalar join) eval_run_agy_gpt-oss-120b-medium_1794196331.json
Gemini 3.8 Flash (High) 75.0% 6 / 8 51.9s 4.3 ms Tasks 01 & 06 timed out during deep reasoning eval_run_agy_gemini-3.8-flash-high_1794196172.json
Golden Ground Truth 100.0% 8 / 8 N/A 3.8 ms Baseline Verification (0% False Negatives) eval_run_offline_1794186318.json
Offline Reference / Naive 0.0% 0 / 8 N/A 2.6 ms 100% Trap Detection (Metric skew, row loss, O(N²) joins) eval_run_offline_1794186320.json

🌐 Live Interactive Benchmark Report Dashboard (GitHub Pages)

The full interactive reporting suite is deployed live at https://sethusrinivasan.github.io/sql-frontier-eval/, tested across 108,027,582 records across 148 tables with DuckDB physical operator execution plans:

  • 📊 Live Executive Benchmark Dashboard: High-level KPI summary, multi-model leaderboard, domain scorecards, Ubuntu OOM-kill root cause analysis, real-time live search, domain filter pills, and query status table.
  • 🔍 120 Query Deep-Dive Pages (also in reports/queries/): Dedicated per-query reports detailing:
    • What It Means: Business scenario, analytical requirement, and semantic failure trap analysis.
    • Graphical Execution Plans: Physical operator trees with radiant flame highlights (🔥 BOTTLENECK) on nodes consuming $\ge 20%$ cost or heavy latency.
    • Data Volume Details: Underlying table counts, schema, and volume (MiB/GiB) with rich scenario data preview.
    • Colored & Formatted Queries: Side-by-side candidate SQL vs golden reference vs setup DDL with syntax highlighting.
    • Result Sets: Side-by-side tabular candidate vs expected outputs.
  • 📦 Self-Contained Report Bundle (reports.tar.gz): 560 KiB compressed archive containing the entire dashboard and all 120 deep-dive pages for offline deployment.

📖 For in-depth analysis and charts, read the full Benchmark Report.
🎥 For video presentation and slides, see the Video Walkthrough Script and Interactive Slides.
📋 For the official hackathon submission summary, see Submission Summary.


📊 The 8-Category Analytical Failure Taxonomy

ID Task Definition Category Real-World Scenario Frontier Model Limitation Detected
01 task_01_fanout.json Chasm Trap / Fan-Out Orders + Discounts + Shipments aggregation Joins 1:N tables before GROUP BY, multiplying sums 4x
02 task_02_sessionization.json Sessionization (Gaps & Islands) Clickstream event logs with 30-min timeout Misuses ROW_NUMBER() instead of cumulative step flags
03 task_03_scd2_join.json SCD Type 2 Point-in-Time Joins Historical currency conversion as-of transaction Misses open-ended NULL bounds (valid_to IS NULL), dropping active rows
04 task_04_three_valued_logic.json Three-Valued Logic in Anti-Joins Un-churned customer cohort extraction Uses NOT IN with subquery NULLs, returning 0 rows
05 task_05_window_frame_bounds.json Window Frame Default Bounds Cumulative balance with duplicate timestamps Uses default RANGE instead of ROWS BETWEEN ..., bunching peer rows
06 task_06_funnel_precedence.json Strict Funnel Precedence Multi-stage user onboarding conversion Loses chronological ordering between sequential steps
07 task_07_quadratic_self_join.json Quadratic Self-Joins Rolling 7-day moving revenue Substitutes window scans with O(N²) triangular self-joins
08 task_08_sargable_pruning.json Non-SARGable Partition Pruning Event table date filtering BETWEEN date boundary leaks into next month; wraps date in string functions

🌐 Comprehensive 120-Task & 5-Domain Evaluation Suite

In addition to the 8 core failure-mode traps, SQL-Frontier-Eval includes 102 modern analytical tasks across five frontier analytical domains plus 10 hardened frontier trap challenges:

Domain Queries DuckDB Engine Capabilities Evaluated Real-World Scenario Focus
1. Temporal & Time-Series Q01 – Q25 ASOF JOIN, generate_series, IGNORE NULLS LOCF, time_bucket Tick-level trade matching, point-in-time FX, sensor gap filling, bitemporal audit, multi-touch attribution
2. Vector & Embeddings Q26 – Q50 array_cosine_similarity, array_distance, array_inner_product, FLOAT[N], QUALIFY RAG retrieval, ticket deduplication, ColBERT MaxSim in SQL, K-Means clustering, MMR diversity reranking
3. Search & Hybrid Retrieval Q51 – Q75 PRAGMA create_fts_index, match_bm25, levenshtein, jaro_winkler_similarity, RRF Reciprocal Rank Fusion (BM25 + Dense Vectors), fuzzy typo-tolerant matching, faceted JSON filters
4. Graph & Hierarchies Q76 – Q88 WITH RECURSIVE, path tracking arrays, transitive closures Multi-tier BOM cost rollups, reporting hierarchies, sybil fraud ring tracking, critical path scheduling
5. Warehouse & Statistical Q89 – Q102 Pre-aggregated CTEs, NOT EXISTS, PIVOT, UNPIVOT, list_transform, MAD, NTILE Chasm trap fan-out prevention, 3-valued null logic, robust outlier detection, Kaplan-Meier survival
6. Hardened Frontier Traps 111 – 120 ASOF tolerance, array cycle guards, RRF rank fusion, normalized decay Exposing hallucinated recursive syntax, array type errors, and revenue over-allocation
  • Full Golden Ground-Truth Baseline: 120 / 120 Passed (100.0%) (eval_run_offline_1794210761.json).
  • Hardened Trap Model Cracks: GPT-OSS 120B passed 6/9 (66.7%), stumbling on circular CTE recursion (Task 112), array concat operator (Task 116), and unnormalized decay attribution (Task 119). Gemini 3.8 Flash achieved 9/9 (100.0%).
  • Detailed Catalog Manifest: catalog/analytical_queries_100.json and catalog/queries/.
  • Automated CI/CD: GitHub Actions workflow runs the 120-task golden suite, unit tests, and offline naive trap assertions with zero LLM requirements.

🏗️ Architecture & Hardened Features

sql-frontier-eval/
├── generate_reports.py           # Scaled production report & execution plan profiler (1M+ rows)
├── reports/                      # Static HTML report suite
│   ├── index.html                # Executive Benchmark Dashboard & multi-model scorecards
│   ├── style.css                 # Dark-mode styling, glowing bottleneck cards, plan trees
│   ├── script.js                 # Search filtering, domain tabs, SQL copy handlers
│   └── queries/                  # 120 Query deep-dive reports (task_001.html - task_120.html)
├── reports.tar.gz                # Compressed 560 KiB distribution archive
├── verify.sh                     # 1-Step verification script (Unit tests + Gold + Offline)
├── run_eval.py                   # Unified CLI benchmark runner
├── requirements.txt              # Pinned dependencies (DuckDB, Pandas, PyArrow, etc.)
├── conftest.py                   # Pytest test path configuration
├── BENCHMARK_REPORT.md           # Comprehensive publication report & empirical insights
├── SUBMISSION_SUMMARY.md         # Official hackathon form submission text
├── VIDEO_WALKTHROUGH_SCRIPT.md   # 4.5-minute video walkthrough teleprompter script
├── walkthrough_presentation.html # Interactive HTML presentation slide deck
├── sql_frontier_eval_walkthrough.mp4 # Full 1080p narrated video walkthrough with burned-in CC (3m 53s)
├── video/                        # Video generation assets, slide scenes & SRT captions
│   ├── build_video.py            # Automated video compilation pipeline
│   └── walkthrough_captions.srt  # Synchronized closed-caption subtitles
├── harness/
│   ├── engine.py                 # SQLEvalEngine: In-memory DuckDB sandbox with JSON profiling
│   ├── grader.py                 # SQLGrader: Semantic value equivalence & operator checks
│   └── llm.py                    # Multi-provider client (Antigravity CLI + OpenRouter)
├── tasks/                        # 8 Challenge definitions with setup, golden, and naive SQL
│   ├── task_01_fanout.json
│   ├── task_02_sessionization.json
│   ├── task_03_scd2_join.json
│   ├── task_04_three_valued_logic.json
│   ├── task_05_window_frame_bounds.json
│   ├── task_06_funnel_precedence.json
│   ├── task_07_quadratic_self_join.json
│   └── task_08_sargable_pruning.json
├── tests/
│   ├── test_harness.py           # 8 Unit tests for engine sandboxing, sorting, profiling
│   └── test_llm.py               # 4 Unit tests for SQL regex block parsing
└── results/                      # Persisted JSON benchmark runs
    ├── eval_run_gemini-3.8-flash-medium_1794186799.json  # 8/8 Passed (100.0%)
    ├── eval_run_claude-opus-4-6-thinking_1794187547.json # 7/8 Passed (87.5%)
    ├── eval_run_claude-sonnet-4-6_1794187183.json        # 7/8 Passed (87.5%)
    ├── eval_run_gpt-oss-120b-medium_1794187234.json      # 7/8 Passed (87.5%)
    ├── eval_run_gemini-3.8-flash-low_1794186841.json     # 7/8 Passed (87.5%)
    ├── eval_run_gemini-3.8-flash-high_1794187896.json    # 6/8 Passed (75.0%)
    ├── eval_run_offline_1794186318.json                  # Golden Ground Truth (100.0%)
    └── eval_run_offline_1794186320.json                  # Naive Trap Baseline (0.0%)

Key Hardening Highlights

  • Zero-Flakiness Row Sorting: Relational SQL outputs without ORDER BY are unordered multisets. SQLGrader sorts both candidate and golden DataFrames deterministically before value assertion, preventing false failures caused by parallel worker row permutations.
  • Decimal & Floating Tolerance: DuckDB DECIMAL types are coerced to float64 so numerical tolerance (atol=1e-3, rtol=1e-3) applies reliably.
  • Deep Physical Plan Profiling: Traverses DuckDB's EXPLAIN (FORMAT JSON) operator tree to measure intermediate cardinalities and automatically flag anti-patterns (CROSS_PRODUCT, BLOCKWISE_NL_JOIN, PIECEWISE_MERGE_JOIN).
  • Automated Walkthrough Diagnostics: On evaluation failure, the harness automatically generates a comprehensive terminal walkthrough featuring:
    • Beautified SQL: Candidate and golden queries formatted with uppercase keywords and clean CTE/join indentation via sqlparse.
    • Tabular Comparison: Actual vs. expected output side-by-side in readable ASCII grid tables.
    • Root Cause Discrepancy: Exact cell divergence, arithmetic delta, inflation multiplier, and analytical failure explanation.

📐 Benchmark Design & Technical Architecture Decisions

To ensure empirical fidelity, reproducibility, and mathematical rigor on large-scale analytical workloads, SQL-Frontier-Eval implements the following architectural decisions:

1. Interactive Static HTML Reporting & Deep-Dive Explorer (reports/)

  • Executive Dashboard (reports/index.html): Modern dark-mode reporting interface featuring hero KPI metrics (overall pass rate, latency, data volume), analytical domain scorecards, multi-model leaderboard comparison, system Root Cause Analysis (RCA) incident alert, real-time query search, domain filter pills, and query status matrix.
  • Per-Query Deep-Dive Pages (reports/queries/<task_id>.html): 120 dedicated deep-dive reports providing:
    • Analytical Significance & "What It Means": Detailed problem background, scenario definition, and explanation of why frontier LLMs stumble on semantic traps.
    • Beautified & Syntax-Highlighted Queries: Formatted SQL tabs displaying Candidate Query, Golden Reference Query, and Setup DDL with Pygments GitHub Dark syntax highlighting.
    • Tabular Query Results Comparison: Side-by-side display of actual candidate output vs. expected golden ground truth.
    • Underlying Table Metadata: Exact row counts, computed data volumes in bytes/MiB, column definitions, and rich data preview rows.

2. Graphical Execution Plans & Operator Bottleneck Profiling

  • DuckDB 2.0 Physical Operator Tree: Extracted via EXPLAIN ANALYZE (FORMAT JSON) without requiring external rendering engines.
  • Pipeline Latency Distribution: Pre-calculated CSS-driven proportional latency distribution bar visually displaying execution share across all operators.
  • Flowchart Tree Layout: Operator cards depicting operator type, execution latency (ms), processed rows, data volume (MB), and table/filter/projection predicates.
  • Automated High-Cost Bottleneck Highlighting: Operators consuming $\ge 20%$ of total query runtime or exhibiting heavy execution latency ($\ge 50\text{ ms}$) receive glowing radiant highlights (🔥 BOTTLENECK) to visually spotlight performance bottlenecks.

3. Production Data Scaling (1M+ Records) & Rich Scenario Synthesis

To prevent toy test artifacts from masking memory bottlenecks or latency divergences, underlying tables scale to at least 1,000,000 records per table using mathematically modeled distributions:

  • Unique Sequential Keys (max_id + i): Sequential primary keys eliminate artificial key collisions and Cartesian key inflation.
  • Continuous Measures with Box-Muller Gaussian Normal ($Z_1, Z_2, Z_3, Z_4$): Financial stock prices, FX rates, and sensor telemetry follow Gaussian normal distributions ($Z = \sqrt{-2\ln(U_1)}\cos(2\pi U_2)$) anchored around domain seed averages.
  • Discrete Measures with Binomial Bell Curves: Central limit theorem sums of 4 normal variables model realistic discrete counts (order quantities, share volumes, attendance counts).
  • Poisson Microsecond Arrival Jitter: High-frequency order books and clickstream timestamps incorporate Poisson arrival intervals (+ (i * 20 + abs(8.0 * z1)) * INTERVAL '1 microsecond').
  • Domain-Realistic Vocabularies: Rich scenario distributions for tickers (NVDA, AAPL, MSFT, GOOGL, etc.), ISO currencies (USD, EUR, GBP, JPY), URL paths, and IoT cluster nodes replace repetitive clones.

4. Star-Schema Dimension Protection & Quadratic Scalability Controls

  • Dimension vs. Fact Table Separation: In multi-table analytics, small dimension, reference, parameter, and query tables (e.g., $K$ centroids in K-Means clustering task_035, intent prototypes task_049, query token embeddings task_033, and lookup thesauri task_061) are preserved at their seed counts (2–10 rows) while massive fact tables scale to 1,000,000 records. This prevents semantically incorrect $10^6 \times 10^6 = 10^{12}$ cross-joins while accurately benchmarking production warehouse queries.
  • Quadratic & Recursive Workload Safeguards: Tasks with unindexed $O(N^2)$ triangular all-pairs self-joins (t1.id < t2.id, t1.id != t2.id, array_cosine_similarity in tasks task_031, task_032, task_036, task_040, task_073) and recursive graph traversals (WITH RECURSIVE in Graph & Hierarchy tasks) scale to 2,500 records. At 2,500 records, unpartitioned triangular self-joins compute $\frac{2500 \times 2499}{2} = 3,123,750$ vector comparisons (executing in 0.5s–1.5s), evaluating realistic high-cardinality queue deduplication without triggering 500-billion-pair combinatorial stalls.

5. Memory Hardening & Ubuntu Systemd-OOMD Root Cause Analysis (RCA)

  • Incident Investigation: On 2026-11-09 00:38:46 UTC, evaluation runs aborted due to Ubuntu's systemd-oomd terminating the GNOME terminal scope (vte-spawn-...scope) with SIGKILL when memory pressure reached 61.9% (>50% user-slice threshold for >20s). The process reached 12.1 GB RAM and 1.4 GB swap, spilling 546.8 MB to DuckDB temporary storage.
  • Root Cause: During evaluation of gpt-oss-120b-medium on cyclic dependency graph tasks, generated SQL produced unbounded recursive CTE loops. Without explicit memory ceilings, DuckDB allocated up to its default 12.0 GB ceiling (80% system RAM).
  • Permanent Safeguards Applied:
    1. Strict Engine Memory Ceiling: Configured SET max_memory = '2GB'; in harness/engine.py to guarantee that DuckDB in-memory operations never exceed host operating system thresholds.
    2. Active Watchdog Timers: Integrated a 15-second query execution watchdog in engine.py and a 10-second watchdog in generate_reports.py via Python threading.Timer(timeout, con.interrupt). Runaway queries cleanly raise DuckDB's native InterruptException without crashing the host process or causing OS memory pressure.

6. Physical Plan Optimization & Why LLMs Fail at Database Physical Design

For a comprehensive architectural analysis, see PHYSICAL_PLAN_OPTIMIZATION_AND_LLM_ANALYSIS.md.

  • The Columnar Indexing Paradox: Across 120 analyzed execution plans, sequential table scans account for only 5.5% of analytical query runtime, while WINDOW (30.0%), HASH_GROUP_BY (19.5%), and ORDER_BY (15.2%) dominate execution. Traditional secondary B-Tree/ART indexes do not optimize analytical operations (ASOF JOIN, WINDOW, range scans); DuckDB's vectorized engine bypasses ART indexes in favor of SIMD vector chunk scans and Min-Max Zone Maps.
  • The True Physical Levers: Physical clustering (ORDER BY at ingestion) achieves a 1.86x speedup on range scans by enabling row-group skipping. For vector embeddings, HNSW indexes (vss extension) prevent linear $O(N \times D)$ brute-force scans. For entity resolution, multi-attribute compound blocking keys eliminate 250-billion-operation Cartesian blowups.
  • Why Frontier LLMs Fail on First Go:
    1. The SELECT-Only Prompt Blindspot: LLMs are benchmarked as non-privileged analytical clients, treating schema and physical layout as immutable constants.
    2. OLTP Muscle Memory: Over 90% of training data stems from MySQL/Postgres OLTP workloads, causing models to hallucinate B-tree indexes that are useless in columnar OLAP.
    3. Cardinality & Distribution Blindness: Models generate SQL in a statistical vacuum, unaware of table row count (10 vs. 1,000,000) or distinct value skew (NDV).
    4. Absence of Execution Feedback: Text-to-text generation lacks runtime profiling (EXPLAIN ANALYZE) to detect operator bottlenecks or memory spills.
    5. Defaulting to Antiquated ANSI Anti-Patterns: Models default to correlated subqueries (70.5x slower than native ASOF JOIN) and triangular joins ($O(N^2)$ vs. $O(N)$ window frames).

🚀 Quick Start

1. Prerequisites & Installation

Ensure you have Python 3.10+ installed.

# Clone and navigate to repository
git clone https://github.com/sql-frontier-eval.git
cd sql-frontier-eval

# Create virtual environment and install dependencies
python3 -m venv .venv
source .venv/bin/activate
pip install -r requirements.txt

2. One-Step Verification

Run the verification suite to execute unit tests, verify ground-truth baselines, and test offline failure detection:

./verify.sh

🧪 Running Evaluations

Sanity Verification (Ground Truth Baseline)

Validates that all golden queries pass 100% with zero false negatives:

python run_eval.py --test-gold

Offline Mode (Testing Local Reference Queries)

Evaluates candidate queries stored in task files without requiring an API key:

python run_eval.py --model offline

When an eval fails, a detailed walkthrough is automatically printed:

==========================================================================================
❌ EVALUATION FAILURE WALKTHROUGH: E-Commerce Financial Aggregation without Join Fan-Out
Category: Metric Inflation / Chasm Trap | Verdict: VALUE_MISMATCH
==========================================================================================

1. QUERIES EXECUTED
[Candidate Query (Tested - Latency: 3.6ms)]
  SELECT m.merchant_id,
         m.merchant_name,
         sum(o.base_amount) AS total_gross_sales, ...
  FROM merchants m
  JOIN orders o ON m.merchant_id = o.merchant_id
  LEFT JOIN order_discounts d ON o.order_id = d.order_id
  LEFT JOIN order_shipments s ON o.order_id = s.order_id
  GROUP BY m.merchant_id, m.merchant_name;

2. TABULAR QUERY RESULTS COMPARISON
[Actual Candidate Output] (1 rows x 5 columns):
  +----+---------------+------------------+---------------------+-------------------------+
  |    |   merchant_id | merchant_name    |   total_gross_sales |   total_discount_amount |
  +====+===============+==================+=====================+=========================+
  |  0 |             1 | Acme Electronics |                 400 |                      30 |
  +----+---------------+------------------+---------------------+-------------------------+

[Expected Golden Output] (1 rows x 5 columns):
  +----+---------------+------------------+---------------------+-------------------------+
  |    |   merchant_id | merchant_name    |   total_gross_sales |   total_discount_amount |
  +====+===============+==================+=====================+=========================+
  |  0 |             1 | Acme Electronics |                 100 |                      15 |
  +----+---------------+------------------+---------------------+-------------------------+

3. FAILURE ANALYSIS & ROOT CAUSE
• Value Discrepancy: 'total_gross_sales' at Row 0 expected 100.0, got 400.0 (+300.00 / 4.0x inflation).
• Root Cause: Joining two 1:N child tables before grouping created a 2 * 2 = 4x Cartesian fan-out.
==========================================================================================

Live Evaluation via Frontier CLI (Antigravity Models)

Benchmark frontier models directly in authenticated environments:

# Evaluate Gemini 3.8 Flash with Medium Reasoning (100% Score)
python run_eval.py --model gemini-3.8-flash-medium

# Evaluate Claude Opus 4.6 Thinking (87.5% Score)
python run_eval.py --model claude-opus-4-6-thinking

# Evaluate Claude Sonnet 4.6 Thinking (87.5% Score)
python run_eval.py --model claude-sonnet-4-6

# Evaluate GPT-OSS 120B Medium (87.5% Score)
python run_eval.py --model gpt-oss-120b-medium

# Evaluate Gemini 3.8 Flash with Low Reasoning (Fast 4s Inference)
python run_eval.py --model gemini-3.8-flash-low

# Evaluate Gemini 3.8 Flash with High Reasoning
python run_eval.py --model gemini-3.8-flash-high

Live Evaluation via OpenRouter

Benchmark frontier models across providers using OpenRouter:

export OPENROUTER_API_KEY="sk-or-v1-..."

# Evaluate Claude 3.5 Sonnet
python run_eval.py --model "anthropic/claude-3.5-sonnet" --verbose

# Evaluate GPT-4o
python run_eval.py --model "openai/gpt-4o" --verbose

# Evaluate Gemini 2.0 Flash
python run_eval.py --model "google/gemini-2.0-flash-001" --verbose

All evaluation runs automatically persist structured JSON reports in results/eval_run_<model>_<timestamp>.json.


🛠️ Running the Test Suite

pytest tests/ -v

All 12 unit tests verify engine sandboxing, profile extraction, column matching, deterministic sorting, and SQL block extraction.


🤝 AI-Assisted Development Acknowledgement

In compliance with hackathon submission guidelines, we transparently disclose and acknowledge the use of AI-assisted development:

  • Pair Programming Partner: Developed with the assistance of Google Antigravity (AGY) agentic AI pair programming system powered by Gemini 3.8 Flash.
  • Human-in-the-Loop Oversight: Benchmark design, analytical failure taxonomy curation, test fixture definitions, execution profiling rules, and mathematical verification were directed and validated by human analytical engineering review.

📜 License

MIT License.

About

No description, website, or topics provided.

Resources

Stars

1 star

Watchers

0 watching

Forks

Releases

Packages

Contributors

Languages