[Bug] Unittests Fail with Quoted Source Table Columns in dbt Framework

[megetron3]

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

We have encountered an issue with the dbt unittests framework where our source table columns are quoted. During unit testing, these cases fail due to the unquoted column name being labeled as an "invalid identifier."

Expected Behavior

Unittests should pass successfully.
The framework should correctly identify and use quoted column names as specified in the source tables.
There should be no "invalid identifier" errors due to quoting issues.

Steps To Reproduce

Source Table:

CREATE TABLE "source_table" (
    "column1" INTEGER,
    "column2" VARCHAR(255)
);

Model:

SELECT
    "column1",
    "column2"
FROM
    {{ ref('source_table') }}

Test:

unit_tests:
  - name: test_quoted_columns
    description: "Ensure columns of a given input will be quoted."
    model: source_table
    given:
      - input: ref('source_table')
        rows:
          - {"column1": 1, "column2": 'value1'}
          - {"column1": 2, "column2": 'value2'}
    expect:
      rows:
        - {"column1": 1, "column2": 'value1'}
        - {"column1": 2, "column2": 'value2'}

Relevant log output

No response

Environment

- OS: iOS
- Python:
- dbt: 1.8.7

Which database adapter are you using with dbt?

No response

Additional Context

No response

[dbeatty10]

Thanks for opening this @megetron3 !

This looks like the same thing as reported in dbt-labs/dbt-adapters#205, so I'm going to close this as a duplicate.