Write SQL queries
You use SQL mode to write SQL statements, primarily used for reading data. GUI mode provides you with an interface to construct queries that write or modify data with greater accuracy than a raw SQL statement. This can prevent unintentional changes due to erroneous SQL statements.
Perform API requests
API resources, such as REST, GraphQL, and SOAP APIs, also use a GUI to construct queries. You can also use the RESTQuery resource to manually interact with APIs that are not configured as an existing resource.
If your resource uses OAuth, make sure Share credentials between users is enabled on the resource configuration page. This ensures workflows run automatically.