Quoting relations and columns (discussion)

[ericmuijsvanoord]

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]

@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]

@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]

also I want to tie-in an issue that I opened over 3 years ago
related: dbt-msft/dbt-sqlserver#91