Is there a way to expand list parameters as in

c.execute("select * from foo where bar in (%s)", ((1,2,3,4),)

or do i have to format the list with "... (%s)" % ...

?