I want to implement following query in Peewee ORM:
with parms (tag) as (
values ('tag1'), ('tag2'), ('tag3')
)
select t.*
from the_table t
join params p on p.tag = t.tag;
How can I implement below raw query?
Also, a quick question. I have lots of values (more than 10K) in IN operations. And it takes lot of time to execute that query and my application freezes out. Is there any better solution replacing postgres IN operation?
For e.g.
all_blogs_ids = [...] # more than10K ids
Blog.select().where(id.in_(all_blogs_ids)