Awesome Query has evolved into an extension that focuses on API integration and data extraction/transformation. 

Currently it is in beta and feedback is welcome.

==============================OLD==============================
Awesome Query provides a business friendly query language and a smart editor, with which you can query your data in sheets easily.  

Latest update:
-- Support multi-word header name
--Improve UI and editor
--Specify header row number

Features: 

Query language
-- More friendly syntax compared to google's query language
-- Use header (multiple words) row instead of A, B, C, D
-- Easy date type support
-- Support both ad-hoc run and QUERY function creation
 
Smart editor
-- Syntax highlighting
-- Validate query syntax during editing
-- Auto-completion based on sheets structure

Automation (under consideration/development)
-- Save query
-- Schedule or run query automatically
-- Deliver/publish the query result based on criteria