Column comments in sql model

The problem I’m having

I am creating models using sql and would like to add comments / descriptions for each column.

The context of why I’m trying to do this

I am building a data catalog which pulls table and column metadata from the database.

What I’ve already tried

Have tried inline comments and a schema.yml file containing just the basic column name and description per mode. None of these worked.