It has joins now, but Google says this: "Joins have size restrictions due to implementation details. Essentially it means that the data on both sides of the JOIN clause cannot be large. For example, select count() FROM big_table JOIN another_big_table will fail, but select count() FROM big_table JOIN small_table will succeed. Because this size restriction depends on many complex variables, the best way to handle joins is to try your join, and if it returns a "Table too large for JOIN query" error, limit the data handled by join clauses by specifying fewer fields or rows."
If someone is in the pilot, I'd love to know some different table/result set cardinalities where you hit the "too large for join" limit, as well as what your data and join conditions look like.