Sure you can, just store them in .sql files and have your CI system auto deploy them.