[BUG]: defaultNow() syntax error

[ArtemGolovko]

What version of drizzle-orm are you using?

0.28.5

What version of drizzle-kit are you using?

0.19.13

Describe the Bug

Syntax error while executing drizzle-kit push:mysql with schema below.

export const users = mysqlTable('users', {
    id: serial('id').primaryKey(),
    joined_at: timestamp('joined_at', { mode: 'date', fsp: 0 }).notNull().defaultNow()
});

Here is full sql error:

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 '(now()),

This syntax error occurs when using defaultNow() in schema. It generates incorrect sql (now()) that causes the error.

Expected behavior

deafultNow() in schema should have generated now() instead of (now()).

Environment & setup

Name	Version
Mysql	5.7.37-log MySQL Community Server
OS	Windows 10

[Angelelz]

I'll close this one in favor of #921.
It will be fixed by #1114