How to change only certain conditions in complex where clause

[g-u-t-h-m-a-n]

I have a sql query with a reasonably complex where clause:

select table1.col1,
       table1.col2
from table1
where table1.col1 > 0
  and table1.col2 >= 'XXX1'
  and table1.col3 <> 8
  and 'XXX2' <> '0'
  and 'XXX3' in (select col4 from table4)
  and (('XXX3' = '0')
    or
       (
               (
                       (('XXX4' = '1') and (table1.col1 <> table1.col2))
                       or
                       (('XXX5' = '2') and (table1.col2 <> table1.col3) and (table1.col2 = '0') and
                        (table1.col4 = table1.col5))
                   )
               and
               exists(select 1
                      from table2, table3
                      where table3.col1 = table2.col1
                        and table3.col6 = table2.col2
                        and (table3.col6 = table2.col1 or 'XXX5' = '1')
                        and table3.col6 >= table3.col2
                        and table3.col3 <= (case when table2.col2 = -1 then table3.col5
                                                 else table2.col2 end)
                        and table3.col5 >= table3.col10)
           )
    )
  and ('XXX2' = '0' or table1.col7 = 1)
  and table1.col6 = 'XXX0'

Everywhere where 'XXX[0-9]' is part of a condition, I want to comment out that change that particular condition to 1=1 (for the sake of example). So the desired output is:

select table1.col1,
       table1.col2
from table1
where table1.col1 > 0
  and 1=1
  and table1.col3 <> 8
  and 1=1
  and 1=1
  and ((1=1)
    or
       (
               (
                       ((1=1) and (table1.col1 <> table1.col2))
                       or
                       ((1=1) and (table1.col2 <> table1.col3) and (table1.col2 = '0') and
                        (table1.col4 = table1.col5))
                   )
               and
               exists(select 1
                      from table2, table3
                      where table3.col1 = table2.col1
                        and table3.col6 = table2.col2
                        and (table3.col6 = table2.col1 or 1=1)
                        and table3.col6 >= table3.col2
                        and table3.col3 <= (case when table2.col2 = -1 then table3.col5
                                                 else table2.col2 end)
                        and table3.col5 >= table3.col10)
           )
    )
  and (1=1 or table1.col7 = 1)
  and 1=1;

I tried playing around with the transform method, but can't figure it out. In other queries where I plan to use this for there can be other constructs/variants. So I need it to be a bit general. Something in the gist of:

if 'XXX' in node.expression.right or 'XXX' in node.expression.left:
    node.condition = condition('1=1')

Love the library, btw. Better than sqlparse, one reason being that it runs on Windows...

[georgesittas]

The following seems to work correctly for your example, but I'm not sure if it's what you're after:

from sqlglot import exp, parse_one

def transformer(node):
    if isinstance(node, exp.Predicate):
        if 'XXX' in node.text('this') or 'XXX' in node.text('expression'):
            return parse_one("1=1")
    return node

print(parse_one(<your query>).transform(transformer).sql(pretty=True))

[g-u-t-h-m-a-n]

This seems to be exactly what I need, thanks! I didn't realise that the condition could be in two different parts of the tree.