ExSQL.Json (exsql v0.1.1)

The json1 function family's data layer: a JSON parser/renderer over an order-preserving representation, plus path navigation ($.a.b[0], $[#-1]).

JSON values map to:

:null, true, false
numbers (integer, float, or preserved real literal token)
strings (binaries)
{:array, [value]}
{:object, [{key, value}]} — pairs in source/insertion order, as SQLite preserves object member order in json_object and rewrites

Hand-rolled rather than JSON/:json because object member order is observable in SQLite's output.

Summary

Functions

get(jv, arg2)

merge_patch(target, patch)

RFC 7386 MergePatch, as json_patch() implements it: patch objects merge recursively (null members delete), anything else replaces the target.

object_key_text(key)

parse(text)

parse_json5(text)

parse_path(arg1)

Parses $, $.key, $."quoted key", $[2], $[#-1] paths.

parse_sqlite_jsonb(blob)

pretty(jv, indent \\ " ")

remove(jv, arg2)

render(jv)

sqlite_jsonb_strict?(blob)

sqlite_jsonb_superficial?(blob)

to_sql(n)

Converts a JSON value to its SQL representation (leaves stay scalar, containers render).

to_sqlite_jsonb(jv)

type_name(n)

The json_type() name for a JSON value.

write(jv, arg2, value, mode)

Writes value at the path. :insert only creates missing leaves, :replace only overwrites existing ones, :set does both. Missing intermediate containers leave the document unchanged, as in SQLite.

Types

object_key()

@type object_key() ::
  binary()
  | {:jsonb_path_key, binary()}
  | {:jsonb_integer_literal, 4, binary(), integer()}
  | {:jsonb_escaped_text, 9, binary(), binary()}
  | {:jsonb_escaped_key, 8 | 9, binary(), binary()}

path_step()

@type path_step() ::
  {:key, binary()} | {:index, non_neg_integer()} | {:last_offset, integer()}

t()

@type t() ::
  :null
  | boolean()
  | number()
  | {:real_literal, binary()}
  | {:jsonb_integer_literal, 4, binary(), integer()}
  | {:jsonb_real_literal, 5 | 6, binary()}
  | {:jsonb_text, 10, binary()}
  | {:jsonb_escaped_text, 8 | 9, binary(), binary()}
  | binary()
  | {:array, [t()]}
  | {:object, [{object_key(), t()}]}