To start working on a new query, click "New Query" on the home page or under the Queries menu in the navigation bar.

Redash supports live auto-complete - simply start typing and you'll get the relevant suggestions. For schemas with more than 5000 tables+columns start typing and then hit ctrl/cmd+spacebar to see suggestions.