pass a tuple as parameter to sql query

[kll]

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>

[Kaniz]

Hi @kll, To pass a tuple as a parameter to an SQL query, you can make use of the execute method of the cursor object in Python. The execute method allows you to prepare and run a database query or command, and it accepts a dictionary as a parameter where you can pass your tuple values.

[kll]

@Kaniz  I am writing sql using the magic command in the cell block, `%%sql`. Is there a way to pass a parameter in the query without using the `execute` method of the cursor object? Can you please share an example?