The kind of "quote marks" you can use around named depends on what database you are using. And also what the "settings" in that database are.
But for a name such as CIAlias
you don't need any marks.
You should be able to just use
Select channel_id AS ClAlias from tblchannel AS TbAlias where tbAlias.IS_DEFAULT = 1;
You only need "quote marks" around aliases if the aliases are the same as keywords in the DB you are using.
Note: For MySQL, you need to use `...` marks (those are "back ticks"...they are *NOT* apostrophes!). For Access, you need to use [...]. For SQL Server, whether you can use "..." or not depends on a setting in the DB.