Add Database Patches

In this set up, how are the patches gonna work for making changes to specific values in a specific column? For example, if we have a table with a column that we need to trim some value, like replace the values "/foo/bar/foo1", "/foo/bar/foo2" for "foo1", "foo2" accordingly ...