.project

.project does client side ResultSet projection.

If .limit is used, then the projection is only applied to the rows retrieved.

Since the columns are projected when they are retrieved, it does not cost extra memory.

Syntax

The syntax is basically similar to SELECT clause, but only simple column names and AS clause is supported.

It should be noted that " is always used to quote column names.

Example

.project a AS "Column 1", b
SELECT * FROM MyTable ORDER BY a;