Databrick adding column with with column in select statement

In sql server we can create new column by adding some value like below

select *, new_column = fixed_value from table 

samething I want to replicate in Databricks Sql , but in databrick getting error new_column is not present. How to do this in Databrick for temp table

>Solution :

in databricks you use aliases, which you also can use in sql server and other rdms

 select *,  1 as new_column from table