What isn't supported by the autogenerated migrations? The docs don't mention what is and isn't supported. And is trigger creation all via raw sql?

[Mekagojira8]

Am very impressed with what I've seen of piccolo so far, I just have the above questions. I would like to know what degree on manual intervention is required when generating migrations.

Thank you

[sinisaos]

@Mekagojira8 Supported: adding, dropping and renaming columns, tables and schemas.
Not supported: triggers, composite constraints (there is a PR to enable this), full text search, pgvector, etc., but it's very easy to do migrations by adding a raw sql to run method in an empty migration file like this or in previous examples. Hope this helps.