Spatial Query in Drizzle using MySQL

I'm not able to find an example of how to create a Spatial Index as explained in this tutorial.

https://www.endpointdev.com/blog/2021/03/spatial-queries-with-mysql/

Can I please get some help with how to do the following in Drizzle ORM?

CREATE TABLE restaurants (
name VARCHAR(100),
location GEOMETRY NOT NULL,
SPATIAL INDEX(location)
);