I have to use this syntax in MySQL Workbench, but it's throwing this in Azure Data Studio for MySQL: ...

MySQL 1064, in this case, will require you to actually do the proper coding of the e-commerce website. This is one of the examples, where 1064 can point to an underlying problem.

Guess we could also ignore errors in the migration package if it's a drop statements, however that's dangerous as there can be other errors like invalid SQL too.