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
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

# Parameter Pattern Guidelines

## Two Types of Parameters

### 1. Interactive Parameters: `{{PARAM}}`
- **Purpose**: Prompted at execution time
- **Usage**: Values that change frequently (dates, sources, filters)
- **Example**: `{{SOURCE}}`, `{{DATE}}`, `{{STATUS}}`
- **Behavior**:
  - Prompts user for value when executing with `\sx`
  - Remembers history of previous values
  - Can cycle through history with `\spn` / `\spp`

### 2. Environment Variables: `${VAR}`
- **Purpose**: Resolved from environment at runtime
- **Usage**: Dynamic values that auto-refresh (JWT tokens, credentials)
- **Example**: `${JWT_TOKEN}`, `${API_KEY}`, `${USER}`
- **Behavior**:
  - NOT prompted - left as-is for sql-cli to resolve
  - Reads from environment variables
  - Automatically uses latest value (e.g., refreshed JWT token)

## Examples

### Query with Both Types
```sql
WITH WEB trades AS (
    URL 'https://api.trading.com/trades'
    HEADERS (
        'Authorization': 'Bearer ${JWT_TOKEN}',  -- Environment variable (auto-refreshed)
        'Content-Type': 'application/json'
    )
    BODY '{
        "Source": "{{SOURCE}}",      -- Interactive parameter (prompted)
        "Date": "{{DATE}}"            -- Interactive parameter (prompted)
    }'
)
SELECT * FROM trades;
```

### Execution Flow
1. Press `\sx` to execute
2. Prompted for `{{SOURCE}}` - enter "Bloomberg"
3. Prompted for `{{DATE}}` - enter "2024-03-27"
4. `${JWT_TOKEN}` is NOT prompted - resolved from environment
5. Query executes with resolved values

### Setting Environment Variables
```bash
# In your shell or .bashrc/.zshrc
export JWT_TOKEN=$(curl -s http://localhost:5001/token | jq -r .token)

# Or in nvim before executing
:!export JWT_TOKEN="your-token-here"
```

### Auto-refresh Pattern
For tokens that expire every 10 minutes:
```bash
# In a background script
while true; do
    export JWT_TOKEN=$(curl -s http://auth-server/token | jq -r .token)
    sleep 600  # Refresh every 10 minutes
done
```

## Summary
- Use `{{}}` for values you want to be prompted for
- Use `${}` for environment variables that should auto-refresh
- Never mix the patterns - they serve different purposes
- `${}` is perfect for JWT tokens that refresh frequently