sql-cli 1.73.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

#!/usr/bin/expect -f

set timeout 2
spawn ./target/release/sql-cli test_nav.csv -e "select * from data"

# Wait for initial display
expect "1/10"

# Test j (down arrow)
send "j"
expect "2/10"

# Test k (up arrow)  
send "k"
expect "1/10"

# Test G (go to last)
send "G"
expect "10/10"

# Test gg (go to first)
send "gg"
expect "1/10"

# Test 5G (go to line 5)
send "5G"
expect "5/10"

# Clean exit
send "q"
expect eof