.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.
The syntax is basically similar to SELECT clause, but only simple column
AS clause is supported.
It should be noted that
" is always used to quote column names.
.project a AS "Column 1", b SELECT * FROM MyTable ORDER BY a;