Formula column documentation & GAQL (or SQL?) query capabilities

It would be great to see some more power built into formula columns and some 
better documentation on the capabilities. I could see this product as a great 
way to make our business data accessible and (highly) available for consumption 
by Google Spreadsheets, but if users need to scrub data downstream (or if DBAs 
need to scrub and merge data upstream of the fusion table) it sorta defeats the 
purpose of hosting data here.

If Google Analytics datasets could also be imported with GAQL and if tables 
could be dynamically pulled and cached using popular standards (SQL) and the 
column formula language could come to resemble the power (if not the syntax) of 
Google Spreadsheets, this product could become an extremely powerful marketing 
stack for startups and SMBs. 

Fusion tables already serves NGOs and the media industry, and with some more 
powerful features it could bring Big Data to small business too. Someone 
somewhere is going to release a great and affordable product that lets 
marketers overlay sales, customer and analytics data against public datasets 
like weather patterns and CPI trends, and it seems like Google already has a 
head start to be first to market with that.
--------------------------------------------------------------------------
NOTE: Use this form to suggest new features for Google Fusion Tables
website or API.  For BUGS, please e-mail us at googletables-
feedback@google.com.

Your "star" vote on requests in this issue tracker helps the Fusion Tables
team prioritize work on the most useful features.

By submitting this form you agree to the Google Terms of Service
(http://www.google.com/accounts/TOS) and the following additional term:
In addition to the Content license you grant to Google in Section 11 of the
Google Terms of Service, you agree that Google may, at its option, use your
Content to provide support for, or to develop, correct or improve Google's
current or future products and services, without any compensation to you.

Thanks for the suggestion!
--------------------------------------------------------------------------

Original issue reported on code.google.com by jazriel...@jewelry.com on 28 Apr 2013 at 3:44

qwerin / fusion-tables

Formula column documentation & GAQL (or SQL?) query capabilities #1271