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.

ReferenceReference

Select SQL WHERE

GroupBy SQL GROUP BY

Counts, CountsBy SQL COUNT

Insert, Append SQL INSERT

Delete, Drop SQL DELETE

DeleteDuplicates SQL UNIQUE

Union, Catenate, Merge SQL UNION

JoinAcross SQL JOIN