#2490 feat: Configurable object/column name formatting options for targets
Issue created by
dluo-sig
Feature scope
Targets (data type handling, batching, SQL object generation, tests, etc.)
Description
It would be helpful if there is a way to configure the column and object names that get mapped from the extractor.
1. direct mapping - names as-is
2. snake_case
3. PascalCase
Nice to have: some targets also have the ability to specify column names that are outside of the normal specs. For example, SQL Server can have column names with any character when qualified with square brackets, PostgreSQL/Snowflake can do the same with double quotes, etc. This would be an additional option to use the appropriate identifiers across the board when referencing objects/fields at the target. It would not be desirable to always force this option, as for example, Snowflake becomes case-sensitive when double quotes are provided.
meltano/sdk