Alias containing space in SQL using firebird database

Question

I have an SQL statement and I would like to have an alias with a space. For example:

select name as User name from users;

I tried different syntaxes but it fails.

select name as "User name" from users;
select name as 'User name' from users;
select name as {User name} from users;
select name as [User name] from users;

database version: Firebird 2.5

Help me please

Answer 1

I would advise you to simply stop wanting the space -- it is a hassle to deal with delimited identifiers in any database.

But, as the documentation explains, Firebird does not necessarily support them:

• Delimited identifiers are available in Dialect 3 only. For more details on dialects, see SQL Dialect.