When we define stored procedures, functions, triggers or events, we have to use DELIMITER:

DELIMITER $$

CREATE PROCEDURE ...

BEGIN

    ...

END $$

DELIMITER ;

This is the only way to write an SQL file that can be run by the mysql client.

But several database versioning tools break when they find DELIMITER. Some examples are Prisma and Postgrator.

In my tests, those tools just work if you remove DELIMITER and always use ";" as a delimiter. They seem to always understand where instructions end.

We need a way to write SQL files that work no matter how we run them. So please make the CLI work without DELIMITER or make connectors work with DELIMITER.