I was told by a developer that yes, AS clauses can be used to change the name of the table as it is stored locally, but no, PowerSync can not sync from a view. In the future views will hopefully be unnecessary thanks to Sync Streams which allow more complex queries.