料理都市SQL可視化プロンプト

WITH input(city) AS ( VALUES (:city) ), kb AS ( SELECT dishes(city) d, ingredients(city) ing, processes(city) pr, supply(city) sc, landmarks(city) lm, native_script(city) scr, manifesto(city) man, palette(city) pal FROM input ), hero AS ( SELECT l, dish_for(d, l) AS dish FROM kb, unnest(letters_of(city)) l ), -- C₁ top AS ( SELECT taxonomy_panels(ing) AS p FROM kb ), -- C₂ base AS ( SELECT supply_narrative(sc, lm) AS n FROM kb ), -- C₃ bot AS ( SELECT flow_diagrams(pr) AS f FROM kb ), -- C₃ type AS ( SELECT bilingual(scr, man, city) AS t FROM kb, input ) -- C₄ SELECT framed_poster( hero ⊕ top ⊕ base ⊕ bot ⊕ type, bg=>'dark', panels=>'cream', accent=>pal ) AS culinary_city FROM hero, top, base, bot, type, kb -- C₁: CHECK ( letters legible AND dishes ∈ kb.d ) -- C₂: CHECK ( taxonomy authentic AND labeled ) -- C₃: CHECK ( narrative present AND flows authentic ) -- C₄: CHECK ( script correct AND manifesto present ) -- C₅: CHECK ( one sheet AND palette consistent AND hero dominant ) -- forbidden rows (lorem / wrong facts / generic letters / missing taxonomy / wrong script / clutter) violate CHECKs ;