SQL operates as a direct method declaring and selecting data for extraction from a structured set of tables. The process of querying data in SQL is to select/declare the information needed and return as a single structured table.

CQL, by contrast uses a query flow, where individual query steps can be chained together using the | (pipe) symbol in a fashion similar to the Unix shell. Query process and transformation effectively happens from the data source (repository) through to the result set. For example, a typical statement might be:

SELECT field1, field2 FROM table WHERE condition ORDER BY field1;

In LogScale this might look like:

condition 
| sort(field1)

In LogScale this will produce a table and through the UI you can select the fields to view. To create a specific table:

condition 
| sort(field1) 
| table([field1, field2])

When migrating SQL queries: