sql-cli 1.71.1

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

using System.Collections.Generic;

namespace JsonSelector.Models
{
    /// <summary>
    /// Request model for JSON querying
    /// </summary>
    public class QueryRequest
    {
        /// <summary>
        /// Field selectors - key is output column name, value is selector expression
        /// </summary>
        public Dictionary<string, string> Select { get; set; } = new();

        /// <summary>
        /// Optional WHERE conditions for filtering
        /// </summary>
        public Dictionary<string, object> Where { get; set; } = new();

        /// <summary>
        /// Output format: "json" or "csv"
        /// </summary>
        public string OutputFormat { get; set; } = "json";

        /// <summary>
        /// Optional limit on number of rows
        /// </summary>
        public int? Limit { get; set; }
    }

    /// <summary>
    /// Response model
    /// </summary>
    public class QueryResponse
    {
        public List<string> Columns { get; set; } = new();
        public List<List<object>> Rows { get; set; } = new();
        public int RowCount { get; set; }
        public string Format { get; set; } = "json";
    }
}