I wanted to confirm a few limitations on the SQL API: Documentation states that joins aren't allowed, seems this extends to subqueries and CTE's as well? UPDATE and ALTER statements are not supported through the SQL API