Pass iterator and loop through SQL cells

[sumau]

I often have to run the same SQL query against multiple tables. A simple example is dropping tables:

DROP TABLE IF EXISTS customer;
DROP TABLE IF EXISTS lineitem;

It would be great if we could pass in an iterator to the SQL cell. It might require a new input variable at the bottom of the SQL cell?

[mscolnick]

you can maybe do this in python instead

import duckdb

tables = [...]

for table of tables:
   duckdb.sql(f"DROP TABLE IF EXISTS {table}")

[sumau]

That’s what I’m currently doing, but thought it would be cool if you could do it in a SQL cell and keep the syntax highlighting etc… SQL hasn’t got a proper solution for looping and this looked like a good alternative. But maybe not worth it 😄

[sumau]

to be fair it's hard to remember to change the engine and there's so many ways you can loop through variables I don't think the complexity is worth it so closing this idea :-)