...
The data within a table, view, or dataset can also be retrieved by using a SQL-like query language from the Synapse web interface. To query a table, view, or dataset, select the funnel wrench icon in the upper righthand right-hand menu to reveal the advanced search bar.
...
By default, the advanced search bar will be pre-populated with a query to capture all of the data contained in the table, view, or dataset. For example:
...
See the REST API docs for a list of all queries that can be performed.
Toggling Between Simple and Advanced Search
You can toggle from the simple search to the advanced search without losing your query results. For example, if you selected treatment arm A, age of 23:64, and gender as female, the query will be preserved in the advanced search bar. However, this feature is unidirectional because the advanced search allows for parameters that are not available with facets. Therefore, switching from advanced to simple search will result in resetting the search query. Synapse will warn you before your search is reset.
...
...
.
Querying Tables, Views, and Datasets Programatically
...