SQLite does not accept temporary column names in a table/view alias.
That's why it is reporting a syntax error near the left parenthesis of:
> … as bar("k", "v")
PostgresSQL docs describe aliases with column names in:
[](https://www.postgresql.org/docs/13/queries-table-expressions.html#id-1.5.6.6.5.7.3)
But the SQLite syntax diagram of the FROM clause does not allow such a syntax:
[](https://sqlite.org/syntax/table-or-subquery.html)