Using list of possible values

[polkapolka]

Is there syntax for submitting a list of parameters and testing if a table value is within that list?
An example of the kind of query I am describing.

'''
select * from number_table as n
where n.number in ['one','two','three']
;
'''

[vail130]

I would use an instance of Param for the array of numbers, then pass the array as a param when you actually execute the query.

number_table = Table('number_table')
numbers = Param('numbers')
query = str(
    SELECT('*')
        .FROM(number_table)
        .WHERE(number_table.number.IN(numbers))
)