Support for migration files format (specifically, dbmate)

[TheCoreMan]

Love this project!!!

So, migration files in dbmate have a specific format and some assumptions built in:

-- migrate:up
CREATE TABLE ...

-- migrate:down
DROP TABLE ...

Assumptions that don't work well with the linter include:

migrate:up and migrate:down implicitly run in a transaction

But

1. the linter is raising Running statement while holding ACCESS EXCLUSIVE lock on the down commands.
2. the transactions might be turned off using a comment of transaction: false

migrate:up and migrate:down are actually separate commands

But the linter raises valid lints like pglint/safety/multipleAlterTable.

What do y'all feel about creating some specific parsers and marking files using some comments/frontmatter/external config to mark them as dbmate-style files?