Retrovisione

with context as (
  select describe_schema('sales') as schema,
         business_goal('increase_roas') as goal
),
candidates as (
  select llm_sql(schema, 'trend conversioni mobile vs mese scorso') as sql1,
         llm_sql(schema, 'roas per canale e device, last 90d') as sql2
  from context
),
validated as (
  select validate_readonly(sql1) as safe_sql
  from candidates
),
answer as (
  select run_sql(safe_sql) as rows
  from validated
)
select chart('line', rows, 'date','conversions_mobile') as figure
from answer;

with context as (
  select describe_schema('sales') as schema,
         business_goal('increase_roas') as goal
),
candidates as (
  select llm_sql(schema, 'trend conversioni mobile vs mese scorso') as sql1,
         llm_sql(schema, 'roas per canale e device, last 90d') as sql2
  from context
),
validated as (
  select validate_readonly(sql1) as safe_sql
  from candidates
),
answer as (
  select run_sql(safe_sql) as rows
  from validated
)
select chart('line', rows, 'date','conversions_mobile') as figure
from answer;