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

Counts , CountsBy — SQL COUNT

Insert , Append — SQL INSERT

Delete , Drop — SQL DELETE

DeleteDuplicates — SQL UNIQUE

Union , Catenate , Merge — SQL UNION

JoinAcross — SQL JOIN