"create procedure from class" with a separate class definition seems like overkill compared to using "create procedure MyTableProcedure as select ...". The inline definition makes it more obvious which column is referenced. Would it be clearer for the schema statements that define an identical starting table and an identical procedure to be constructed using preset strings, so I don't have to think about them, as in

        final String simpleSchema1 = initial_mytable + "alter table mytable ..." + mytable_proc;

As is, I need to inspect ALL the commands to make sure that the base definition and proc are not something different.