Code Generator: Support WHERE In many columns with Lists

[hfhbd]

Description

sql-psi 0.5.0 supports https://github.com/AlecStrong/sql-psi/issues/273, now code gen should support it too:

CREATE TABLE Test(field1 INTEGER NOT NULL, field2 INTEGER NOT NULL);

selectWhereMany:
SELECT * FROM Test
WHERE (field1, field2) < (?, ?);

Should emit this code:

selectWhereMany(
     listOf(
        selectWhereManyValues(field1 = 1, field2 = 2),
        selectWhereManyValues(field1 = 2, field2 = 1),
     )
)

[shellderp]

sql-psi does not actually support

selectWhereMany:
SELECT * FROM Test
WHERE (field1, field2) IN ?;

it only supports lessthan/greaterthan, not IN (I think)

It also requires LP/RP around the right hand

[hfhbd]

Yes, fixed.