[BUG]: MySql syntax error after setting mode: "date" in timestamp

[ElPrudi]

Report hasn't been filed before.

• I have verified that the bug I'm about to report hasn't been filed before.

What version of drizzle-orm are you using?

0.40.0

What version of drizzle-kit are you using?

0.30.5

Other packages

No response

Describe the Bug

After setting a mysql timestamp like timestamp('created_at', { mode: "date" }).notNull().defaultNow(), it returns an error when trying to get an object from that table:

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ', iat = 1741345539' at line 1

    at PromisePool.query (node_modules/.pnpm/[email protected]/node_modules/mysql2/lib/promise/pool.js:36:22)
    at MySql2PreparedQuery.execute (node_modules/.pnpm/[email protected]_@[email protected][email protected][email protected][email protected]_4ae2dd7e7485ff5e84f46a03732803c4/node_modules/src/mysql2/session.ts:121:31)
    at MySqlSelectBase.execute (node_modules/.pnpm/[email protected]_@[email protected][email protected][email protected][email protected]_4ae2dd7e7485ff5e84f46a03732803c4/node_modules/src/mysql-core/query-builders/select.ts:1056:25)
    at MySqlSelectBase.then (node_modules/.pnpm/[email protected]_@[email protected][email protected][email protected][email protected]_4ae2dd7e7485ff5e84f46a03732803c4/node_modules/src/query-promise.ts:31:15)
    at process.processTicksAndRejections (node:internal/process/task_queues:105:5)

[ElPrudi]

I think I've bricked my drizzle stuff, because no matter how much I try to revert it, I still get this error.

[ElPrudi]

Okay, even drizzle-kit pull generates broken SQL for me as this error still doesn't go away. I have to drop drizzle.