this is a feature we could support pretty easily relative to singer. https://github.com/datamill-co/target-postgres/issues/138

giving a choice of what you want a given source data type to be mapped to.

e.g. source type is

array<string>

and we let you have the option of mapping that to

array<string>

or

json

or

string

, etc.

would be curious to figure out how important this feature is to people.

if it is valuable it would be fun to pursue. partially because it is hard for singer to support given the architecture of the tool so it could be a cool differentiator.

don’t know how it is supported in non-OSS products like fivetran.