Support for custom SQL-extending grammar

What language do you work on?

We have a custom tool for applying and reverting migrations. SQL script surrounds with some meta information about migration. Also, there are a few new shortcuts for replacing SQL boilerplate. The tool that can parse and execute this scripts.

It may looks like:

AUTHOR ivan.ivanov;

BEGIN MIGRATION WITH AUTO UNDO

CREATE TABLE user (
  id INTEGER NOT NULL PRIMARY KEY,
  firstname TEXT NOT NULL
);
CREATE INDEX i_user_firstname ON user(firstname);

END MIGRATION

I follow the instructions to support syntax but do not know how to work with SQL inside migration. And is there any way to expand SQL syntax with new words.

I'd try to implement a separate template language instead

see com.intellij.psi.templateLanguages.TemplateLanguage API

Could you please provide any examples or links to documentation

No docs unfortunately.

I've found some 3rd-party implementations on github:

https://github.com/Camelcade/Perl5-IDEA/blob/master/src/com/perl5/lang/tt2/TemplateToolkitLanguage.java

https://github.com/KronicDeth/intellij-elixir/blob/master/src/org/elixir_lang/eex/Language.java

https://github.com/jhsx/GoJetPlugin/blob/master/src/io/github/jhsx/jet/JetLanguage.java

Thanks a lot