Why our ETL tool doesn’t do transformations

Hey Jake! What about something like geocoding, where you have to query an HTTP API for each record? It seems like doing transformations in SQL will always have a ceiling relative to a scripting language like python, no?