stor reset   # Optional
stor create --table-name test_table --columns { id: int, value: str }
# => ╭────────────┬────────────────╮
# => │ test_table │ [list 0 items] │
# => ╰────────────┴────────────────╯

# We can insert new row with a string with a single quote just fine
stor insert -t test_table --data-record {
  id: 1
  value: "Doesn't fail"
}
# => ╭────────────┬───────────────────────────╮
# => │            │ ╭───┬────┬──────────────╮ │
# => │ test_table │ │ # │ id │    value     │ │
# => │            │ ├───┼────┼──────────────┤ │
# => │            │ │ 0 │  1 │ Doesn't fail │ │
# => │            │ ╰───┴────┴──────────────╯ │
# => ╰────────────┴───────────────────────────╯

# We can update the row as long as it doesn't have a single quote
stor update -t test_table --where-clause 'id = 1' --update-record {
  id: 1
  value: "This also works"
}
# => ╭────────────┬──────────────────────────────╮
# => │            │ ╭───┬────┬─────────────────╮ │
# => │ test_table │ │ # │ id │      value      │ │
# => │            │ ├───┼────┼─────────────────┤ │
# => │            │ │ 0 │  1 │ This also works │ │
# => │            │ ╰───┴────┴─────────────────╯ │
# => ╰────────────┴──────────────────────────────╯

# But an update with a single-quote in the string will fail
stor update -t test_table --where-clause 'id = 1' --update-record {
  id: 1
  value: "But this doesn't work"
}
# => Error:
# =>   × Failed to open SQLite connection in memory from update
# =>    ╭─[source:1:1]
# =>  1 │ nu
# =>    · ▲
# =>    · ╰── near "t": syntax error in UPDATE test_table SET id = 1, value = 'But this doesn't work' WHERE id = 1 at offset 54
# =>    ╰────