sql-cli 1.79.4

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

# Tier 3 — scalar functions: string, math, conditional, NULL handling.
# These probe semantic parity (arg order, rounding, CASE) and surface gaps.

[[case]]
id = "fn_upper"
data = "trades.csv"
sql = "SELECT UPPER(symbol) AS u FROM trades"

[[case]]
id = "fn_lower"
data = "trades.csv"
sql = "SELECT LOWER(symbol) AS l FROM trades"

[[case]]
id = "fn_length"
data = "instruments.csv"
sql = "SELECT name, LENGTH(name) AS n FROM instruments"

[[case]]
id = "fn_substring"
data = "trades.csv"
sql = "SELECT SUBSTRING(symbol, 1, 2) AS s FROM trades"
# SQL SUBSTRING() is 1-indexed, matching the SQL standard / DuckDB.
# (The C# `.Substring()` method form stays 0-indexed — .NET semantics.)

[[case]]
id = "fn_trim"
data = "instruments.csv"
sql = "SELECT TRIM(name) AS t FROM instruments"

[[case]]
id = "fn_concat"
data = "international_sales.csv"
sql = "SELECT region || '-' || country AS combo FROM international_sales"

[[case]]
id = "fn_abs"
data = "trades.csv"
sql = "SELECT ABS(price - 185) AS d FROM trades"

[[case]]
id = "fn_round"
data = "trades.csv"
sql = "SELECT ROUND(price, 0) AS r FROM trades"

[[case]]
id = "fn_ceil_floor"
data = "trades.csv"
sql = "SELECT CEIL(price) AS c, FLOOR(price) AS f FROM trades"

[[case]]
id = "fn_mod"
data = "trades.csv"
sql = "SELECT volume % 100 AS m FROM trades"

[[case]]
id = "fn_coalesce"
data = "instruments.csv"
sql = "SELECT instrument_id, COALESCE(coupon_rate, 0) AS cr FROM instruments"

[[case]]
id = "fn_case_simple"
data = "trades.csv"
sql = "SELECT symbol, CASE WHEN price > 185 THEN 'high' ELSE 'low' END AS tier FROM trades"

[[case]]
id = "fn_case_searched"
data = "international_sales.csv"
sql = "SELECT region, CASE WHEN amount > 2000 THEN 'big' WHEN amount > 1000 THEN 'mid' ELSE 'small' END AS bucket FROM international_sales"

[[case]]
id = "fn_cast_int"
data = "trades.csv"
sql = "SELECT CAST(price AS INTEGER) AS pi FROM trades"
# Parser does not yet accept CAST(expr AS type).
expect = "GAP"