Reversible views, triggers etc. [howto]

I'm new to phinx but it seems to be a rock solid tool that cover all my needs. I like that smart "change" method, but if I want to create some view or trigger an so, There is only way how to do by raw query. And that raw query not support reverse action in change method. So I make little investigation how to make it reversible.

1. Use that old methods up() and down(). In up method you can write query for "CREATE OR REPLACE VIEW my_view...." and in down method "DROP VIEW my_view" alongside with reversing other tables.

2. In my opinion is better to prefer smater "change" method because my lazyness to wrote code double if it is not necessary. So the same functionality you reach by this example:

public function change(): void
    {
        $tblA = $this->table("tableA"); //reversible by default in change method
            $tblA->addColumn("name", "string", ["null" => false, "limit" => 255]);
        $tblA->create();


       $this->query("CREATE OR REPLACE VIEW my_view AS SELECT * FROM tableA");

        if(!$this->isMigratingUp) //this is the key 
        {
            $this->query("DROP VIEW my_view");
        }
    }

so it is simple and I hope that help someone to use it.

Start by reviewing the issue's examples using migration change(), up(), down(), query(), and isMigratingUp for views and triggers. Check the existing migration documentation to determine where reversible raw queries are described; done means the supported approach is documented clearly, including reversal behavior.