[BUG] Unable to evaluate valid filters

[joocer]

replicated with sample data:

SELECT * FROM $astronauts
WHERE name LIKE '%o%' 
    AND `year` > 1900
    AND (gender ILIKE '%ale%' AND group IN (1,2,3,4,5,6))

[joocer]

plan for this is:

[
    [
        (`name` like "%o%"),
        (`year` > 1900.0)
    ],
    (
        [
            (`gender` ilike "%ale%"),
            (`group` in [1.0, 2.0, 3.0, 4.0, 5.0, 6.0])
        ]
    )
]

I think the problem is the tuple around the list - that should just be the list without the tuple around it.

[joocer]

Three or more AND conditions result in DNF unable to be processed:

EXPLAIN SELECT * FROM $astronauts
WHERE `year` > 1965 AND gender = 'Male' AND group = 3

[[(`year` > 1965.0),(`gender` = "Male")],(`group` = 3.0)]

which, for ease of reading is:

[[ (A), (B) ], (C) ]

Which should evaluate correctly, but the processor assumes all of the elements in an iterable are the same, the list around (A),(B) isn't able to be processed with the C condition, as these aren't the same.

Putting (C) in a list would solve the validity problem, but it changes the meaning of the filter, that would then be (A and B) or C - what it should be is [(A),(B),(C)]