[question] Is the name of model column must same as table column

[netweaver]

in table_reference mode

Is the name of model column must same as table column ?

Must I use sql_ref mode to build meaningful model in most case?

[goldmedal]

in table_reference mode

Is the name of model column must same as table column ?

You can define the expression of a column to provide a meaningful alias.

Must I use sql_ref mode to build meaningful model in most case?

In general, I recommend using table_reference instead of ref_sql. It can keep your semantic being clean. ref_sql is used to you want to do some pre-processing or if your database supports the table configuration (e.g. Clickhouse's FINAL table ).