It would be helpful to refer to columns from tables created with values(), but their names currently can't be resolved in Turso. The names of the columns generated by SQLite are undefined:

The name of a result column is the value of the "AS" clause for that column, if there is an AS clause. If there is no AS clause then the name of the column is unspecified and may change from one release of SQLite to the next. (source)

but they can still be resolved. Turso could even make column names a part of the stable interface, it would be helpful to developers.

Turso:

turso> values(123);
┌─────┐
│ 0   │
├─────┤
│ 123 │
└─────┘
turso> select `0` from (values(123));
  × Parse error: no such column: 0

SQLite:

sqlite> .mode table
sqlite> values(123);
+---------+
| column1 |
+---------+
| 123     |
+---------+
sqlite> select column1 from (values(123));
+---------+
| column1 |
+---------+
| 123     |
+---------+