prazy1208/text2sql

1-- Few-shot SQL pattern examples (generic) for the Few-Shot Agent.2-- Run against text2sql_db (or: python scripts/run_create_few_shot_examples_schema.py)3 4CREATE SCHEMA IF NOT EXISTS system_schema;5 6CREATE TABLE IF NOT EXISTS system_schema.few_shot_examples (7    id              SERIAL PRIMARY KEY,8    question_text   TEXT NOT NULL,9    sql_query       TEXT NOT NULL,10    query_type      TEXT NOT NULL11);12 13CREATE INDEX IF NOT EXISTS idx_few_shot_examples_query_type14    ON system_schema.few_shot_examples (query_type);15 16COMMENT ON SCHEMA system_schema IS 'Cross-cutting metadata (few-shot examples, etc.)';17COMMENT ON TABLE system_schema.few_shot_examples IS 'Curated question/SQL pairs for few-shot retrieval';18COMMENT ON COLUMN system_schema.few_shot_examples.query_type IS 'Pattern label (e.g. aggregation_groupby, join)';19