When creating a formatting profile there is only one selection for Alias casing, in my personal experience my column alias casing differs from my table alias.

EX:

Select
det.name AS UserName
, det.id AS UserId
, det.phone AS UserPhone
, det.description AS UserBio
FROM dbo.exampletable det

when running through my formaterr with the setting Alias Case set to 'Lower' it changes my column alias's whether they are snake_Case PascalCase to lower

TLDR : have a setting to alter column alias case individually rather than a global alias case option