JSON improvements in SQLite 3.38.0
select id, name, interests from user
where interests->'$.likes'->>'$[0]' = 'reading';
#json
CamelCase <--> snake_case conversion in jq
def camel_to_snake:
[
splits("(?=[A-Z])")
]
|map(
select(. != "")
| ascii_downcase
)
| join("_");