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

# IN Clause vs Contains Method

## Understanding the Difference

### Contains Method
The `.Contains()` method performs a substring search:
```sql
-- This will match any counterparty that has "US" anywhere in the string
SELECT * FROM trade_deal WHERE counterparty.Contains("US")
```
Matches:
- "US Bank"
- "Bank of US"  
- "HSBC US Division"
- "US"

### IN Clause
The `IN` clause performs exact matching:
```sql
-- This will only match if counterparty equals exactly "US"
SELECT * FROM trade_deal WHERE counterparty IN ("US")
```
Matches:
- "US" (exact match only)

Does NOT match:
- "US Bank"
- "Bank of US"
- "HSBC US Division"

## Examples

### To find exact matches from a list:
```sql
-- Find trades with specific counterparties
SELECT * FROM trade_deal WHERE counterparty IN ("US Bank", "JP Morgan", "HSBC")
```

### To find partial matches:
```sql
-- Find any counterparty containing "Bank"
SELECT * FROM trade_deal WHERE counterparty.Contains("Bank")
```

### Combining both:
```sql
-- Find specific banks OR any counterparty containing "US"
SELECT * FROM trade_deal WHERE counterparty IN ("JP Morgan", "HSBC") OR counterparty.Contains("US")
```

## Debugging Tips

1. First check what values exist in your data:
```sql
SELECT DISTINCT counterparty FROM trade_deal
```

2. If IN returns 0 rows, the exact values don't exist. Try Contains instead:
```sql
-- Instead of:
SELECT * FROM trade_deal WHERE counterparty IN ("US")

-- Try:
SELECT * FROM trade_deal WHERE counterparty.Contains("US")
```

3. For multiple partial matches, use multiple Contains with OR:
```sql
SELECT * FROM trade_deal WHERE counterparty.Contains("US") OR counterparty.Contains("UK")
```