Database-Like Operations on Datasets
Wolfram Language Dataset objects allow arbitrary hierarchical data on which a rich set of possible operations can be applied. Dataset objects can also directly represent traditional relational databases, on which Wolfram Language functions can be used to perform traditional SQL-like operations.
Select — SQL WHERE
GroupBy — SQL GROUP BY
DeleteDuplicates — SQL UNIQUE
JoinAcross — SQL JOIN