[BUG]: Type error when using subquery in where

[livingforjesus]

What version of drizzle-orm are you using?

0.30.10

What version of drizzle-kit are you using?

0.21.1

Describe the Bug

I get the type error:
Argument of type 'Aliased' is not assignable to parameter of type 'Column<ColumnBaseConfig<ColumnDataType, string>, object, object>'.
Type 'Aliased' is missing the following properties from type 'Column<ColumnBaseConfig<ColumnDataType, string>, object, object>': table, name, primary, notNull, and 14 more.

whenever I'm creating this drizzle code:

const tagsSubquery = db
    .select({
      id: listings.id,
      tag: sql<string>`UNNEST(${listings.tags})`.as('tag')
    })
    .from(listings)
    .where(eq(listings.marketplaceIntegrationId, marketplaceIntegrationId))
    .as('tags');
  const [{ tags }] = await db
    .select({
      tags: sql<SearchTagsResponse>`ARRAY_AGG(DISTINCT tag)`
    })
    .from(tagsSubquery)
    .where(
      and(
        ilike(tagsSubquery.tag, `%${searchTerm}%`),
        notInArray(tagsSubquery.tag, excludeTags!).if(excludeTags?.length)
      )
    );

The type error is on ilike(tagsSubquery.tag, %${searchTerm}%),

The query works but the type error is annoying

Expected behavior

I expect no type error

Environment & setup

postgres db

[adiSuper94]

I am facing the same issue. I am migrating form js to ts this is blocking me.
I know I can do obj["key"]. But then what is the point of ts when I am dodging type checks?

[adiSuper94]

Id be glad to attempt fixing this issue if someone is willing to guide me through it.
@Angelelz

[Angelelz]

Id be glad to attempt fixing this issue if someone is willing to guide me through it.
@Angelelz

I can't offer my help at this time. I haven't been able to help with drizzle development in several months. The first thing I would ask is what does the error say?
Edit: nevermind I just re-read the issue

[adiSuper94]

@Angelelz, cool. Thanks for the reply. I tagged you cuz I have just interacted with you on discord. But if you feel anyone else can help with this, please feel free to tag them instead.

[AndriiSherman]

fixed in drizzle-orm@0.36.2