offloading to helper function the buildup of where statements in sql query in drizzle

I have a helper function that I will utilize in drizzle to build dynamic queries, like this:

How to create Virtual Table with Drizzle ORM?

I am working with Drizzle ORM on a SQLITE database and I need VIRTUAL TABLE.

Drizzle dynamic query table aliasing

Im trying to perform a select alias similar to how it normally is done: