[BUG]: Querying tables with timestamp field in where query not working in aws data api

[livingforjesus]

What version of drizzle-orm are you using?

0.29.3

What version of drizzle-kit are you using?

0.19.13

Describe the Bug

in queries

When making select queries, in where statements if there is a clause that
includes a timestamp field(with timestamps with mode:string), you get an error like

ERROR: operator does not exist: timestamp without time zone >= text; Hint: No operator matches the given name and argument types. You might need to add explicit type casts.

This is because the data api is treating the string timestamp as a text not a string.
So in code like:

const [newUser] = await db.insert(usersTable).values({ name: 'John' }).returning()
const [result] = await db.select().from(usersTable).where(and(eq(usersTable.id, newUser!.id), gte(usersTable.updatedAt, newUser!.updatedAt)))

The select statement doesn't work

Expected behavior

The query should work

Environment & setup

No response