Is there a way to transform to snake_case when mapping columns/creating tables?

Not at the moment, but I see a potential solution similar to what's proposed in https://github.com/meltano/sdk/issues/1502, but using the humps library instead. Do log an issue if this something you'd like sdk-based taps and targets to support.

Created https://github.com/meltano/sdk/issues/2490