Générateur de diagrammes d'échecs éducatifs (Astra SQL)

WITH semantic_model AS ( SELECT classify([TOPIC_OR_PROBLEM]) AS domain, infer_problem_state([TOPIC_OR_PROBLEM]) AS problem_state, infer_problem_objective([TOPIC_OR_PROBLEM]) AS objective, infer_best_diagram(problem_state) AS diagram_type, infer_required_elements(problem_state) AS diagram_elements, derive_analysis_text(problem_state) AS body_copy, derive_problem_caption(objective) AS caption, infer_useful_manual_annotations(problem_state) AS annotations ), page_model AS ( SELECT 'printed instructional publication' AS artifact_type, 'warm matte paper' AS paper, 'classic serif editorial layout' AS typography, 'slight photographed perspective' AS camera, 'grayscale technical diagram' AS diagram_style ) SELECT render FROM educational_print_archive WHERE topic = semantic_model.domain AND page_contains = ARRAY[ body_copy, diagram_type, diagram_elements, caption ] AND diagram_accuracy = 'high' AND handwritten_markup = annotations AND markup_behavior = 'clarifies critical element or path' AND paper_texture = page_model.paper AND typography = page_model.typography AND capture_mode = page_model.camera AND visual_hierarchy = 'prose -> diagram -> caption -> footer' ORDER BY instructional_clarity DESC, print_realism DESC, diagram_legibility DESC, annotation_relevance DESC LIMIT 1;