using Zuleny.Data.Sql;
using Zuleny.NLQuery.Sql;

// 1. Schema by introspection + business vocabulary
var schema = SchemaLoader.Load(connection, SqlDialects.SqlServer);
schema.FindTable("Orders").Synonyms = ["ventas", "pedidos", "sales"];

// 2. One engine per schema
var engine = new NlToSqlEngine(schema);

// 3. Question → parameterized SQL
var r = engine.Translate("ventas por país en 2025", SqlDialects.SqlServer);
if (r.Success)
{
    using var cmd = r.CreateCommand(connection);
    // r.Sql · r.Parameters · r.Explanation · r.Confidence
}