a usecase to query millions of values.

[KVNARK]

have a small use case where we need to query the sql database with 1 million values(dynamically returned from python code) in the condition from python function. eg: select * from id in (1,2,23,33........1M). I feel this is very bad approach. Is there any better way to query the millions of values using select query.

Kindly suggest.

[daniel_sahal · Accepted solution]

You can also create a temporary view with the output from python code (one id = one row) and then inner join the view to the table. IMO will improve readability of your code.