All of these things totally depend upon your business logic. If you want to remove duplicates or you want to implement some kind of format for postal addresses, like keeping pin codes in this format, you can customize your code accordingly and then you can get consistency in the data.
Since the way everyone is moving towards AI, my suggestion will be to lean more towards natural language processing. So rather than writing proper SQL, the way Snowflake is processing or Cloudera is processing things, they should also have a chatbot or something similar where we can simply write things, it understands that particular thing and enhances that particular thing at the back end.
I do remember I used to work for geographical interfaces, where we needed most of the location information. It was a petroleum extraction client. So we needed the location and everything. For that, we used libraries that were more focused on getting the basic distance between two geographical locations and everything. Those kinds of functions, if we wanted to implement them, we used to extract that particular thing from the external libraries and use it.