NamedQuery 支持嵌套 map[string]interface{}, 实现过滤条件

[xiao-xiao-xiao]

/*
{
    sql: `select {{foo}},{{bar}} from tb where address in {{addr}} and {{where}}`,
        data: map[string]interface{}{
        "foo":  "f1",
        "bar":  "f2",
        "addr": []string{"beijing", "shanghai", "chengdu"},
        "where": map[string]interface{}{
            "name in": []string{"1", "2"},
                         "age": 10,
         },
    },
    cond: `select ?,? from tb where address in (?,?,?) and (age=? AND name IN (?,?))`,,
    vals: []interface{}{"f1", "f2", "beijing", "shanghai", "chengdu", 10, "1", "2"},
}
*/

where := map[string]interface{}{
        "foo":  "f1",
        "bar":  "f2",
        "addr": []string{"beijing", "shanghai", "chengdu"},
        "where": map[string]interface{}{
            "name in": []string{"1", "2"},
                          "age": 10,
         },
    },

where["where"] = builder.Omity(where["where"],  []string{"age"})
// 使用此种方式来实现，复杂SQL， 部分条件需要过滤