Design a Query Suggestion & Autocomplete for Analytics

A system that tracks metadata (table schemas, column types, popular queries) and suggests partial or complete queries as the user types...