[solved] drizzle-kit push fails when using with cockroachdb

> drizzle-kit push

drizzle-kit: v0.22.8
drizzle-orm: v0.33.0

No config path provided, using default path
Reading config file '/home/keogami/code/suchajoy/drizzle.config.ts'
Using 'postgres' driver for database querying
[✓] Pulling schema from database...

 Warning  You are about to execute current statements:

CREATE TABLE IF NOT EXISTS "session" (
        "id" text PRIMARY KEY NOT NULL,
        "user_id" text NOT NULL,
        "expires_at" timestamp with time zone NOT NULL
);

CREATE TABLE IF NOT EXISTS "user" (
        "id" text PRIMARY KEY NOT NULL,
        "age" integer
);

DO $$ BEGIN
 ALTER TABLE "session" ADD CONSTRAINT "session_user_id_user_id_fk" FOREIGN KEY ("user_id") REFERENCES "public"."user"("id") ON DELETE no action ON UPDATE no action;
EXCEPTION
 WHEN duplicate_object THEN null;
END $$;


PostgresError: at or near "do": syntax error
    at ErrorResponse (/home/keogami/code/suchajoy/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:79677:27)
    at handle (/home/keogami/code/suchajoy/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:79454:7)
    at TLSSocket.data (/home/keogami/code/suchajoy/node_modules/.pnpm/[email protected]/node_modules/drizzle-kit/bin.cjs:79277:9)
    at TLSSocket.emit (node:events:513:28)
    at addChunk (node:internal/streams/readable:559:12)
    at readableAddChunkPushByteMode (node:internal/streams/readable:510:3)
    at Readable.push (node:internal/streams/readable:390:5)
    at TLSWrap.onStreamRead (node:internal/stream_base_commons:189:23)
    at TLSWrap.callbackTrampoline (node:internal/async_hooks:130:17) {
  severity_local: 'ERROR',
  severity: 'ERROR',
  code: '42601',
  detail: 'source SQL:\nDO $$ BEGIN\n^',
  file: 'lexer.go',
  line: '399',
  routine: 'Error'
}