Enable lower-case (or rather, case-sensitive) field names in Snowflake about dlt

[rudolfix]

@soltanianalytics thank you for investigating this and giving us a proposed fix but also use case for us to test. we are working on this problem quire intensively and there's a PR (#998 ) that finally applies naming convention to all identifiers (also internal + some regexed in the schema :)), allows to control case sensitivity at the destination.

in particular you'll be able to configure or create the destination with desired naming convention and casefolding ie.

from dlt.destinations import snowflake

snow = snowflake(naming="direct", casefold="str")
pipeline = dlt.pipeline(destination=snow)

to get case sensitive snowflake destination enforcing "direct" naming convention on all dlt components (exact interface will be probably slightly different)

I'll ping you when it is ready so you can give us feedback if the PR solves your problem.

[soltanianalytics]

That would be great indeed! Looking forward to this functionality.