SQLite provides several functions for inserting, setting, and replacing values in a JSON document. Specifically, it provides json_insert(), json_set(), and json_replace().

These functions perform similar tasks, and you can sometimes use them interchangeably to a certain point.

But there is definitely a clear difference between each function.

In SQLite, json_tree() is a table-valued function that walks the JSON value provided as its first argument and returns a table consisting of one row for each array element or object member.

We provide the JSON value as an argument when we call the function.

In SQLite, json_each() is a table-valued function that walks the JSON value provided as its first argument and returns a table consisting of one row for each array element or object member.

We provide the JSON value as an argument when we call the function.