Defining custom type with drizzle-orm to support MySQL geospatial POINT data type

point-type.ts

import { sql, type SQL } from 'drizzle-orm';
import { customType, mysqlTable } from 'drizzle-orm/mysql-core';

const pointType = <
    TData extends {
        x: number;
        y: number;
    },
>(
    name: string
) =>
    customType<{ data: TData; driverData: string }>({
        dataType() {
            return 'point';
        },
        toDriver(value: TData): SQL {
            return sql`ST_GeomFromText('POINT(${value.x} ${value.y})')`;
        },
    })(name);

const posts = mysqlTable(
    'Posts',
    {
      postId: varchar('PostId', { length: 36 }).notNull(),
      geoCoordinates: pointType<{ x: number; y: number }>('GeoCoordinates'),
    });