at_lst = ['131','132','133']
at_tup = (*at_lst,)
print(at_tup)
('131','132','133')<div> <div><span>In my sql query, i am trying to pass this on a parameter, however, it doesn't work. <div> <div><div><div><span>%sql<br /><div><span>select * from main.schema.tbl<div><span>where code IN <span>( '{{ at_tup }}' )<div> <div><span>^ This return no result. <div> <div><span>However, when I pass the actual tuple, i get the desired results: <div> <div><div><span>select * from main.schema.tbl<div><span>where code IN ('131','132','133')<div> <div>How do I pass a tuple as a paramter the sql query?</div></div></span></div></span></div></div></div></span></div></div></span></div></div></span></span></div></span></div></span></div></div></div></div></span></div></div>
