[BUG]: Drizzle typebox not supporting array

[renesass]

What version of drizzle-orm are you using?

0.29.2

What version of drizzle-kit are you using?

0.20.13

Describe the Bug

Hey! I'm using drizzle together with typebox and I get the wrong types when using array. See the following example:

import { pgTable } from 'drizzle-orm/pg-core'
import { createSelectSchema } from 'drizzle-typebox'

const shop = pgTable('shop', {
  images: text('images').array()
})

const shopSchema = createSelectSchema(shop)

// Creates the following object:
// TObject<{ images: TNullable<TString>; }>

Probably related to #1416?

Expected behavior

// TObject<{ images: TNullable<TArray<TString>>; }>

Environment & setup

No response

[AndriiSherman]

Marked this PR to be merged

[elliotnash]

Any updates on this? This still seems to be a problem as of drizzle-orm 0.32.2.

[Huliiiiii]

The enumValue of varchar, text is always [string, ...string[]], which cause GetTypeboxType always return TString for any varchar, text, varchar[], text[] column.

drizzle-orm/drizzle-typebox/src/index.ts

Lines 82 to 102 in 6974798

	type GetTypeboxType<TColumn extends Column> = TColumn['_']['dataType'] extends infer TDataType
	? TDataType extends 'custom' ? TAny
	: TDataType extends 'json' ? Json
	: TColumn extends { enumValues: [string, ...string[]] }
	? Equal<TColumn['enumValues'], [string, ...string[]]> extends true ? TString
	: TUnion<TUnionLiterals<TColumn['enumValues']>>
	: TDataType extends 'array' ? TArray<
	GetTypeboxType<
	Assume<
	TColumn['_'],
	{ baseColumn: Column }
	>['baseColumn']
	>
	>
	: TDataType extends 'bigint' ? TBigInt
	: TDataType extends 'number' ? TNumber
	: TDataType extends 'string' ? TString
	: TDataType extends 'boolean' ? TBoolean
	: TDataType extends 'date' ? TDate
	: TAny
	: never;

drizzle-orm/drizzle-orm/src/pg-core/columns/text.ts

Lines 8 to 16 in 6974798

	type PgTextBuilderInitial<TName extends string, TEnum extends [string, ...string[]]> = PgTextBuilder<{
	name: TName;
	dataType: 'string';
	columnType: 'PgText';
	data: TEnum[number];
	enumValues: TEnum;
	driverParam: string;
	generated: undefined;
	}>;

[AndriiSherman]

This one was fixed in the latest drizzle-typebox@0.2.0