[Feature] Adapter get_columns_in_relation macro but using CTE instead of a Relation object

[alexiska]

Is this your first time submitting a feature request?

• I have read the expectations for open source contributors
• I have searched the existing issues, and I could not find an existing issue for this feature
• I am requesting a straightforward extension of existing dbt functionality, rather than a Big Idea better suited to a discussion

Describe the feature

Hi,
I'm attempting to implement functionality similar to the get_columns_in_relation macro, but using a CTE instead of a Relation object. Specifically, I'm looking to use ref() with a CTE. This is similar to the issue discussed here get_columns_in_relation macro but using CTE instead of a Relation object
Could someone please review this feature request and provide guidance or suggestions on how to achieve this functionality? Any insights or potential solutions would be greatly appreciated.

Describe alternatives you've considered

No response

Who will this benefit?

I would like check for a given column and do some operations on that given column.

Are you interested in contributing this feature?

Not sure if I am skilled enough to contribute but would like to if it is not too advanced

Anything else?

No response