> I know a lot of folks are huge fans of writing pure SQL, the lack of type safety and lack of good intergration with source control (I dream of a world where database schemas, functions, security access and the rest can be saved to source control for reproducibility) scare me.
Hey there are some migration tools that play nice with source control. For example, Flyway has repeatable migrations https://flywaydb.org/documentation/tutorials/repeatable, here's some links about this
https://stackoverflow.com/questions/25839666/flyway-strategy...
https://github.com/flyway/flyway/issues/819
https://github.com/flyway/flyway/issues/128