This guide will help you through migrating SQL to APL, helping you understand key differences and providing you with query examples.
extend
: Adds new columns to the result set.project
: Selects specific columns from the result set.where
: Filters rows based on a condition.summarize
: Groups and aggregates data similar to the GROUP BY clause in SQL.sort
: Sorts the result set based on one or more columns, similar to ORDER BY in SQL.|
) to create a data transformation flow.|
) symbol, with each command operating on the results of the previous command. This makes it very easy to write complex queries.