[Bug] Cannot create postgres indexes on columns with CamelCasing

[cscanlin]

Is this a new bug in dbt-core?

• I believe this is a new bug in dbt-core
• I have searched the existing issues, and I could not find an existing issue for this bug

Current Behavior

Exact same issue as the author here:
https://discourse.getdbt.com/t/create-indices-on-a-column-with-camel-casing/11513

I define an index like this:

{{ config(
    indexes=[
        {‘columns’: ["submission_id", “ContractID”]}
    ]
)}}

I get an error:

column "contractid" does not exist

Confirmed that adding quoting does not seem to help. In fact the sql shows the column are quoted, but they are lowercased automatically somewhere:

        create unique index if not exists
  "5481a023e379ef5288517c3dc7a90c0a"
  on "test"."views"."my_view" using btree
  ("contractid", "submission_id")

Expected Behavior

I would expect that the cases I include will be preserved

Steps To Reproduce

Given any postgres database with columns that have upper case characters

Relevant log output

Environment

- OS: Ubuntu 22.04
- Python: 3.10.12
- dbt: 1.9.0

Which database adapter are you using with dbt?

postgres

Additional Context

No response