sql: alias joins on group bys
expr: join raises error if no columns
sql: more exhaustive testing around views