SQLite Forum

Improve sqlite3_column_name() return value documentation
Login
Consider

select 1 as "";

----------
1

which names the column with an empty string, generating a column name of NULL is not so easy.

select 1 as NULL;
Error: near "NULL": syntax error

explain select 1 as ?;
Error: near "?": syntax error