fsqlite-ext-json 0.1.0

JSON1 functions and virtual tables
Documentation

JSON1 foundations for fsqlite-ext-json (bd-3cvl).

This module currently provides:

  • JSON validation/minification (json, json_valid)
  • JSONB encode/decode helpers (jsonb, jsonb_*, json_valid JSONB flags)
  • JSON type inspection (json_type)
  • JSON path extraction with SQLite-like single vs multi-path semantics (json_extract)
  • JSON value constructors and aggregates (json_quote, json_array, json_object, json_group_array, json_group_object)
  • mutators (json_set, json_insert, json_replace, json_remove, json_patch)
  • formatting and diagnostics (json_pretty, json_error_position, json_array_length)

Path support in this slice:

  • $ root
  • $.key object member
  • $."key.with.dots" quoted object member
  • $[N] array index
  • $[#] append pseudo-index
  • $[#-N] reverse array index