search

microsoft / dbt-fabric

MIT License
79 stars 28 forks source link

Quoting relations and columns (discussion) #120

Open ericmuijsvanoord opened 9 months ago

ericmuijsvanoord commented 9 months ago

By default relations and columns are quoted by double quotes " in dbt. What do you think about setting the quoting to [] which is more T-SQL like?

prdpsvs commented 8 months ago

@ericmuijsvanoord , quoting character in dbt is a single character. dbt cannot support [ and ] characters because it has different starting and ending characters. Let me take a look into this to see if there is way to support multiple opening/ending characters.

prdpsvs commented 7 months ago

@ericmuijsvanoord , The double quotes standard is used in dbt-core and adapter implementation way too many places. Standardizing that would not be a small effort and I am putting this on back burner.

dataders commented 6 months ago

also I want to tie-in an issue that I opened over 3 years ago related: https://github.com/dbt-msft/dbt-sqlserver/issues/91