JSONExtractPath returns SQL to extract a value at a dotted path from a JSON column. SQLite: json_extract(col, '$.path.to.key') PostgreSQL: col #>> '{path,to,key}'
(column, path string)
| 37 | // SQLite: json_extract(col, '$.path.to.key') |
| 38 | // PostgreSQL: col #>> '{path,to,key}' |
| 39 | JSONExtractPath(column, path string) string |
| 40 | |
| 41 | // JSONFieldText, JSONFieldEquals and JSONFieldOrder read an item field |
| 42 | // value by its JSON type, identically on both dialects (BUG-3221; the |
no outgoing calls