Re: Advamced DB operations (Create Table, Update, etc) in Tiki 9.1?
You can use the same database patch system used by Tiki itself.
Some documentation is available: Database Schema Upgrade
You will also find hundreds of sample patches in the source tree.
Essentially, all of Tiki's patches have an _tiki suffix. You can drop in files without that suffix and the installer will apply them automatically on update or clean install.