joaoh82 / rust_sqlite / 25135158388

69%

push

github

Phase 7g.1: sqlrite-ask crate (foundational) (#56)

Lays the groundwork for the ask() API across the product surface
(Phase 7g.2-7g.8) by introducing a brand-new workspace member:
the sqlrite-ask crate. It turns an open Connection + a natural-
language question into generated SQL by walking the schema, building
a cache-friendly prompt, and POSTing once to Anthropic's Messages
API.

The engine itself stays pure-SQL — no HTTP, TLS, async, or serde
deps creep in. Anyone embedding SQLRite who doesn't want LLM calls
ignores this crate entirely.

Public API (Rust):

    use sqlrite::Connection;
    use sqlrite_ask::{AskConfig, ConnectionAskExt};

    let conn = Connection::open("foo.sqlrite")?;
    let cfg  = AskConfig::from_env()?;             // SQLRITE_LLM_API_KEY etc.
    let resp = conn.ask("How many users are over 30?", &cfg)?;
    println!("{}", resp.sql);          // generated SQL
    println!("{}", resp.explanation);  // one-sentence rationale

The library deliberately does NOT execute the returned SQL — that's
the caller's call. Per-SDK convenience helpers (ask_run / askRun /
AskRun) ship in 7g.2-7g.8 alongside the per-product wrappers.

Module layout (sqlrite-ask/src/):

  schema.rs      — dump_schema(&Connection) / dump_database(&Database)
                   walks Database.tables alphabetically (deterministic
                   for prompt caching) and renders CREATE TABLE
                   statements with the canonical SQL keywords
                   (INTEGER / TEXT / REAL / BOOLEAN / VECTOR(N) / JSON).

  prompt.rs      — SystemBlock, CacheControl, UserMessage, build_system().
                   Two-block system prompt: frozen rules first (byte-
                   stable across every call regardless of which DB),
                   then the schema dump wrapped in <schema>...</schema>
                   with cache_control: ephemeral. The LLM is asked to
                   reply with strict JSON {"sql": ..., "explanation": ...}.

  provider/    ... (continued)

0 of 137 new or added lines in 5 files covered. (0.0%)

5381 of 7932 relevant lines covered (67.84%)

1.4 hits per line