Function extract_jsonb_path

cpp/deeplake_pg/extension_init.cpp:291–322

/// @{

void extract_jsonb_path(Node* expr, std::vector<std::string>& path, Node** base_col)
{
    if (IsA(expr, OpExpr)) {
        OpExpr* op = (OpExpr*)expr;
        char* opname = get_opname(op->opno);

        if (opname && (strcmp(opname, "->") == 0 || strcmp(opname, "->>") == 0)) {
            Node* left = (Node*)linitial(op->args);
            Node* right = (Node*)lsecond(op->args);

            // Recursively extract path from left side
            extract_jsonb_path(left, path, base_col);

            // Add current key to path
            if (IsA(right, Const)) {
                Const* kc = (Const*)right;
                if (kc->consttype == TEXTOID && !kc->constisnull) {
                    char* key = text_to_cstring(DatumGetTextPP(kc->constvalue));
                    path.push_back(std::string(key));
                    pfree(key);
                }
            }
        } else {
            *base_col = expr;
        }

        if (opname)
            pfree(opname);
    } else {
        *base_col = expr;
    }
}

// Build nested JSON from path: ["a", "b", "c"] with value "v" -> {"a": {"b": {"c": "v"}}}
std::string build_nested_json(const std::vector<std::string>& path, const std::string& value)