Adapt MySql schema statements to SingleStore statements

[mitchwadair]

12 different instructions came from MySQL:

• Create/Rename/Drop Table
• Create/Drop Column
• Create/Drop Index
• Add/Delete Constraints
• Add/Alter/Delete composed primary keys

Convert the mysql syntax to singlestore syntax in sqlgeneration.ts file from drizzle-kit and remove the ones that are not supported by singlestore, if any. Ask SQrL the differences between these MySQL type of statements and SingleStore.

It is also needed to adapt the create table statements on the schema tests in drizzle-kit/tests/singlestore-generated.test.ts

https://github.com/singlestore-labs/s2-drizzle-orm-dev/blob/main/drizzle-kit/tests/singlestore-generated.test.ts