So you can do a
select * from foo where bar IN :#myValues
And then have myValues being expanded into a list of values separated by comma. The trick is to know if the values should be quoted or not, eg
IN (1, 2, 3)
IN ('1', '2', '3')
So we may need a way to specify that. Or defer if its numbering then its not quoted, and non numeric is quoted. But then you may want numeric quoted still.