How do you add a new where clause to an existing sql statement?

[vamshiaruru32]

I am unable to figure how to construct an Expr to pass to AddWhere method. Lets say I have a query like "SELECT * FROM product WHERE price < 500". Now how do I add "discount <= 10"? This is the closest I came to a solution:

    left := sqlparser.NewStrVal([]byte("price"))
    right := sqlparser.NewStrVal([]byte("?"))
    comp := &sqlparser.ComparisonExpr{
        Operator: sqlparser.LessEqualStr,
        Left:     left,
        Right:    right,
    }
    fmt.Printf("%v\n", sqlparser.String(comp))
    sel := stmt.(*sqlparser.Select)
    sel.AddWhere(comp)
    fmt.Printf("%v\n", sqlparser.String(sel))

But this seems to quote the left in single quotes, because I assume it is considering it as a value instead of a column name. So how do I add a column name expr?

[dustin-decker]

I think you'll want to use something like this: https://github.com/vitessio/vitess/blob/v18.0.1/go/vt/sqlparser/ast_test.go#L91

That will provide a Column name instead of a String value type.