Fusion Table SQL Syntax

I am trying to return data in a select statement where I need to do a sub query to return a maximum value. I know the syntax that will accomplish this in a SQL server db but its not translating to a fusion I'd.  Below is what I'm trying to do. Any suggestions would be appreciated.

Select ROWID, User, Status from fusion table id alias where ROWID = ( Select Maximum(ROWID) from table id where user = user.alias))

If there is a simpler way I really just want all users from table with newest status.



subqueries are not possible

see the syntax here SQL Reference Documentation of the Fusion Tables API.

you have to do the queries in 2 steps