Function references

AssembleRecord

AssembleRecord function is supported in SQLite. It takes as a single positional argument a list of elements, where each element is json with fields arg, value, i.e. result of -> operator. Given input list [k_1 -> v_1, ..., k_n -> v_n] it produces a record with n fields, and i-th field name is string value of k_n while i-th value is equal to v_n.

For example:

If call AssembleRecord(["country" -> "Canada", "capital" -> "Ottawa"]) results in record {country: "Canada", capital: "Ottawa"}.

Try it: PLAYGROUND