sql-cli 1.73.0

SQL query tool for CSV/JSON with both interactive TUI and non-interactive CLI modes - perfect for exploration and automation
Documentation 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96

var builder = WebApplication.CreateBuilder(args);

// Add services to the container.
builder.Services.AddControllers()
    .AddNewtonsoftJson(); // Use Newtonsoft for better JToken support

// Add CORS for testing from browser/SQL CLI
builder.Services.AddCors(options =>
{
    options.AddPolicy("AllowAll",
        builder =>
        {
            builder.AllowAnyOrigin()
                   .AllowAnyMethod()
                   .AllowAnyHeader();
        });
});

// Configure JSON options
builder.Services.ConfigureHttpJsonOptions(options =>
{
    options.SerializerOptions.WriteIndented = true;
});

// Add Swagger/OpenAPI support
builder.Services.AddEndpointsApiExplorer();
builder.Services.AddSwaggerGen(options =>
{
    options.SwaggerDoc("v1", new Microsoft.OpenApi.Models.OpenApiInfo
    {
        Title = "JSON Selector API",
        Version = "v1",
        Description = "Transform hierarchical JSON data into tabular CSV format using selector syntax",
        Contact = new Microsoft.OpenApi.Models.OpenApiContact
        {
            Name = "JSON Selector Service"
        }
    });

    // Include XML comments if available
    var xmlFile = $"{System.Reflection.Assembly.GetExecutingAssembly().GetName().Name}.xml";
    var xmlPath = Path.Combine(AppContext.BaseDirectory, xmlFile);
    if (File.Exists(xmlPath))
    {
        options.IncludeXmlComments(xmlPath);
    }
});

var app = builder.Build();

// Configure the HTTP request pipeline.
app.UseCors("AllowAll");

// Enable Swagger UI
app.UseSwagger();
app.UseSwaggerUI(options =>
{
    options.SwaggerEndpoint("/swagger/v1/swagger.json", "JSON Selector API V1");
    options.RoutePrefix = "swagger"; // Swagger UI at /swagger
});

app.UseRouting();

app.MapControllers();

// Add welcome page with API info
app.MapGet("/", () => new
{
    service = "JSON Selector Service",
    version = "1.0",
    description = "Transform hierarchical JSON into tabular data",
    documentation = new
    {
        swagger_ui = "/swagger",
        api_definition = "/swagger/v1/swagger.json"
    },
    endpoints = new[]
    {
        new { path = "/api/query/upload", method = "POST", description = "Simple query with file upload" },
        new { path = "/api/query/direct", method = "POST", description = "Query with JSON in request body" },
        new { path = "/api/messagequery/upload", method = "POST", description = "Message type-aware query" },
        new { path = "/api/messagequery/example/fix", method = "POST", description = "FIX message example query" }
    },
    selectorExamples = new[]
    {
        "body.Symbol - Navigate to nested field",
        "Parties[PartyRole=11].PartyID - Filter array and get field",
        "AllocGrp:sum(AllocQty) - Aggregate array values",
        "Parties[0].PartyID - Get first element",
        "AllocGrp[*].AllocAccount - Get all values"
    }
});

var port = Environment.GetEnvironmentVariable("PORT") ?? "5050";
Console.WriteLine($"JSON Selector Service starting on http://localhost:{port}");
app.Run($"http://localhost:{port}");