You can manually enter a SELECT statement into the Query field. You can use any valid SQL notation of the connected database to build the query.
To open the Query Designer, click Query Designer.
To look up the database schema, click Lookup Schema.
To run the query, click Execute Query.
After you change an existing SELECT statement, always initialize the component before executing another step with the component.